更新时间:2023-09-28 13:01:10
解决问题:
1. 停止服务wampstackMySQL(从开始"菜单中,依次选择控制面板",管理工具"和服务")
1. stop service wampstackMySQL (From the Start menu, select Control Panel, then Administrative Tools, then Services)
1. 在Windows cmd代码中:
1. in windows cmd code:
E:\ Bitnami \ wampstack-5.4.34-0 \ mysql \ bin \ mysqld.exe --defaults-file = E:\ Bitnami \ wampstack-5.4.34-0/mysql \ my.ini wampstackMySQL- init-file = E:\ mysql-init.txt
E:\Bitnami\wampstack-5.4.34-0\mysql\bin\mysqld.exe --defaults-file=E:\Bitnami\wampstack-5.4.34-0/mysql\my.ini wampstackMySQL --init-file=E:\mysql-init.txt
mysql-init.txt代码:
UPDATE mysql.user SET Password = PASSWORD('MyNewPass')WHERE User ='root';冲洗特权;
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;
2. 通过工作台连接到mysql服务器使用新的root密码
2. connect to mysql server via workbench with new root password
3. 重新启动PC或重新启动服务wampstackMySQL
3. restart PC or restart service wampstackMySQL
4. 删除文件mysql-init.txt
4. delete file mysql-init.txt