laragon updating to MySQL 8 not working
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
But I get error after switching to new mysql and starting it.
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!
@SkyWalker : Can you try:
- Stop All
- Rename folder C:\laragon\data\mysql-8 to C:\laragon\data\mysql-8.bak
- Rename C:\laragon\data\mysql to C:\laragon\data\mysql-8
- 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.
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?
@SkyWalker : You're welcome
To restore, just open Menu > Laragon > Terminal and run:
mysql -u root -p < PATH-TO-YOUR-BACKUP.sql
@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.
i just faced same problem and its fixed many thanks for all the community
I had this issue in v8.0.19 when installing it first and I fixed it by removing data/mysql-8 directory and execute
mysqld --initialize-insecurefrom the bin directory of mysql-8.0.19.
Thank you. It works.
But this way can not convert mysql 5.7's data to 8.0. So we should export databases to sql script first.
Check out my upgrade instructions here.