laragon updating to MySQL 8 not working


  • | 322 points

    I Installed Laragon 3.2.3 (Also tried with 3.1 as well)
    I updated to latest mysql 8 from the following link in pic

    0_1527594257321_mysql.PNG

    But I get error after switching to new mysql and starting it.

    0_1527594247229_Capture.PNG0_1527594583748_mysqllog.txt


  • | 152 points

    HOW IS THERE NOT A SINGLE REPLY TO THIS???
    I HAVE THE SAME QUESTION AND I'VE SEARCHED EVERY DARK CORNER OF GOOGLE AND THIS FORUM AND NOTHING.
    HOW DOES THIS HAVE 1.7K VIEWS WITH NOT A SINGLE REPLY??
    I HAVE LARAGON MINT 4.0.14, USED QUICK ADD TO ADD MYSQL 8, AND GOT THE EXACT SAME ERROR.
    I ALSO TRIED DOING IN MANUALLY, NOTHING.
    WE NEED ANSWERS!


  • administrators
    | 115877 points

    @SkyWalker : Can you try:

    1. Stop All
    2. Rename folder C:\laragon\data\mysql-8 to C:\laragon\data\mysql-8.bak
    3. Rename C:\laragon\data\mysql to C:\laragon\data\mysql-8
    4. Start All

    Note: C:\laragon\data\mysql is data dir for MySQL 5.7, when you change to mysql-8, Laragon will upgrade the data dir to MySQL 8 format.


  • | 152 points

    This reply saved me. Thank you so much.
    Sorry for the all caps. I was pretty stressed because I had to search for an answer for 2 hours straight.
    And this finally worked.
    If you could, can you tell me how to restore my previous databases from the backup?
    Thank you.


  • administrators
    | 115877 points

    @SkyWalker : You're welcome :)
    To restore, just open Menu > Laragon > Terminal and run:

    mysql -u root -p < PATH-TO-YOUR-BACKUP.sql
    

  • | 310 points

    @leokhoa Hi, can make a full step by step tutorial on how to upgrade Laragon 5 MySQL to MySQL 8 from scratch ? I am also having a hard time doing this. Thank you. waiting for your reply.


  • | 18 points

    i just faced same problem and its fixed many thanks for all the community


Log in to reply
 

Looks like your connection to Laragon was lost, please wait while we try to reconnect.