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.
Thank you man, you save my day