Update MySQL 5.1 to latest 5.6 version (1 Viewer)

MaxMan23

MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Germany Germany
    I have a connection problem after doing this steps:


    1. Upgrade to MP 1.6 PR.
    2. Use the import/export section of TV Server configuration to export all your channels etc.
    3. Stop the TV service and ensure TV Server configuration is closed.
    4. Uninstall MySQL.
    5. Install MySQL 5.6. Make sure to remember the root username and password that you use for step 9.
    6. Right click the TV Server configuration shortcut on your desktop and select "properties".
    7. Change the "target" from ...\SetupTv.exe" to ...SetupTv.exe" /configure-db ... (note that the quotation marks are important).
    8. Double click on the shortcut. You should now see the database connection popup that you would have seen when you first installed. All the fields should be set with your current database connection parameters.
    9. Configure username and password for the new MySQL 5.6 database. Using the root user is easiest. You can use a different user account if you want, but that requires extra configuration in MySQL which is beyond the scope of this post.
    10. Click "test" and then "save".
    11. Right click the TV Server configuration shortcut on your desktop and select "properties".
    12. Remove the configure-db section that you added.
    13. Open TV Server configuration.
    14. Go to the import/export section.
    15. Import the file exported in step 2.
    This process should give the best possible outcomes in terms of the database.


    When i do step 10 i got an connection Error:
    Bild1.png


    Bild2.png
     

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Germany Germany
    next Error... :)

    Bild3.png


    (Pass is MediaPortal)
     

    MaxMan23

    MP Donator
  • Premium Supporter
  • September 8, 2007
    380
    48
    Germany Germany
    After updating the mysql workbench i could add the user, but i got the same error...

    Bild4.png


    (I also did a restart of my pc)
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    M.Hulot After Update 1.25 internal blu-ray-player doesn't work General Support 8
    M.Hulot Interner Blu-ray-Player spielt nach Update auf 1.25 keine Discs mehr ab Allgemeines Supportforum 2
    E retaining Watch Status when updating? Newcomers Forum 1
    J Update .NET framework? Improvement Suggestions 9
    G Update von MediaPortal Installationsprobleme? 0
    morpheus_xx [Evaluate] Update to VS 2019? MediaPortal 2 4
    Golf4 Nach Windows-Updates läuft TV-Plugin nicht mehr Allgemeines Support- und Diskussionsforum 0
    B MPEM update list never completes. General Support 0
    JJDoherty Updated DTT frequencies for Ireland... Submit: EPG-Grabbers and tuningdetails 1
    Dark Eyes Updated to Windows 10, now TVServer won't work Installation, configuration support 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    M.Hulot Moving Pictures lässt sich nach Windows-Update nicht mehr öffnen Plugins & Erweiterungen 1
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    k12158 [solved] Kein direkter Wechsel von TV-Kanal zu TV-Kanal mehr nach Update? Allgemeines Support- und Diskussionsforum 16
    ajs Mediaportal update to .Net 4.6.2+ MediaPortal 1 13
    Mr6686 [solved] Titan skin broken since update to 1.23 Installation, configuration support 6
    B TV-Server Auto-Update mptvdb after x hours General Support 0
    Terra LAVFilter Plugin cannot be updated (MP1.23) MediaPortal 1 Plugins 10
    TLD Windows 10 1903 feature update General Support 3
    azzuro [WiP] 5043: Update MP1 to VisualStudio 2019 MediaPortal 1 138
    A Problem Windows 10 64 bit prof. Update auf Version 1903(gelöst) Installationsprobleme? 0
    T No TV after updating Windows 10 to latest Version 1903 / OS build 18362.175 (logs attached) General Support 2
    M [solved] Updated Swedish translation for MP 1.24 Submit: Localization of MediaPortal and DeployTool 0
    framug 1.22.0 BasicHome Editor settings for DefaultWide HD skin not kept when update 1.22 3
    Neoculture Bulk file name update My TVSeries 6
    Similar threads

























    Top Bottom