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
    | 111200 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
    | 111200 points

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

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

Log in to reply
 

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