重置/更改mysql root密码 [英] reset/change mysql root password

问题描述

如何在 bitnami wamp堆栈中重置/更改mysql根密码?? >

How to reset/change mysql root password in bitnami wamp stack?

我尝试了此解决方案，但这对我不起作用.在bitnami文件夹中没有文件 \ bin \ mysqld-nt.exe

I trying this solution but this not working for me. In the bitnami folder no have file \bin\mysqld-nt.exe

推荐答案

解决问题:

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

这篇关于重置/更改mysql root密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！