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
Run:
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
Now your AMPPS will run MySQL 5.7.17.
About how to install MySQL by command line, see https://stackoverflow.com/a/42088890