Upgrading Wamp Server to MySQL 8.0.15
So I recently installed the WampServer a few months back, with a pre-installed mySQL 5.7.
But I wanted to take advantage of the NoSQL features that come with mySQL 8.
To update it, I downloaded the latest MySQL version, extracted the folder to the bin directory of wamp64. I then copied the wampserver.conf and my.ini files from the 5.7 folder and pasted it in to the 8 directory.
I ran on the cmd line the following prompt: mysqld.exe --initialize-insecure
I then edited the my.ini file and changed every instance of 5.7 to 8.0.
But now when I run wamp MySQL doesnt start and I get this error: error
Does anyone know what I did wrong or how I can fix this?
Solution 1:
i found this at http://forum.wampserver.com/read.php?2,147674,147689 and it worked for me.
- Exit Wampserver
- Download MySQL version and extract to a folder, e.g. mysql-8.0.2-dmr-winx64
- Copy the contents of the folder to a new mysql subdirectory, e.g. wamp64/bin/mysql/mysql8.0.2
- Open a command windows (as an administrator) on wamp64/bin/mysql/mysql8.0.2/bin/
- Type : mysqld.exe --initialize-insecure --- This will create the right data folder
- Copy wampserver.conf from mysql5.7.14 to mysql8.0.2
- Copy my.ini from mysql5.7.14 to mysql8.0.2
- Edit mysql8.0.2/my.ini and replace all instances of mysql5.7.14 with mysql8.0.2 (then save)
- Run WampServer64 as administrator
Solution 2:
Just go to following Wampserver repository and directly download and install the .exe of any of the component you want, it takes care of configuration.
For database up-gradation you have to import/export your databases manually.
Secondary repository of Wampserver files
Solution 3:
As Gustavo said, it's working like that, but one additional information. If the wamp server is not starting correctly and stop at "orange" take a look at the log file.
Following error appeared:
"mysqld.exe: Error while setting value 'STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER' to 'sql_mode'."
Solution: https://superuser.com/questions/1425573/mysql-8-0-15-not-working-in-wamp-3-1-0
worked for me.