本文档详细介绍了如何将AMPPS的MySQL从旧版本升级到5.7.17。首先，你需要关闭MySQL，然后下载并安装MySQL 5.7.17的win64版本。接着，替换AMPPS中的MySQL文件夹，创建新的数据目录，并复制配置文件。通过命令行初始化MySQL并设置新密码。按照这些步骤操作后，你的AMPPS将运行MySQL 5.7.17。
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
1601
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
