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 picBut 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?
Thank you.
-
@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-insecure
from 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.
https://forum.laragon.org/topic/2017/mysql-8-upgrade-instructions
-
@shmshd
Thank you man, you save my day
-