且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

重置/更改mysql root密码

更新时间: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