Upgrade AMPPS MySQL to 5.7 (Windows)

Many people are asking about how to upgrade AMPPS MySQL to 5.7. I tried to upgrade it successfully and share at here.


1. Please shutdown MySQL first. Then download MySQL 5.7.17-winx64 here.

2. Go to your AMPPS folder (C:\Program Files (x86)\Ampps) and rename mysql folder to mysql-bak

3. Extract the downloaded MySQL Server Archive to AMPPS folder and rename to mysql

4. Create a data directory for MySQL's database's data files.

5. Copy my.ini file from old mysql-bak directory to mysql

6. Install MySQL by mysqld.exe

Open CMD or terminal, cd to C:\Program Files (x86)\Ampps\mysql\bin


mysqld.exe --defaults-file=..\my.ini --initialize-insecure --console


7. Change MySQL password:

Create a file: init.sql with this content:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypass';
Then Run:
mysqld.exe --init-file=..\init.sql

See: https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html 


Now your AMPPS will run MySQL 5.7.17.


About how to install MySQL by command line, see https://stackoverflow.com/a/42088890