如何在Windows中重置mysql密码

问题描述:

Mysql客户端服务器没有打开。我已尝试在cmd提示符下显示ERROR 1045(28000):拒绝用户'root'@'localhost'(使用密码:NO)。为此我有尝试以下程序重置密码。



C:\> C:\Program Files \ MySQL \ MySQL Server 5.0 \\\ mysqld-nt.exe

--defaults-file =C:\\Program Files \\ \\\ MySQL \\ MySQL Server 5.0 \\ my.ini

--init-file = C:\\mysql-init.txt





mysql-init.txt

---------------

UPDATE mysql.user SET Password = PASSWORD('MyNewPass')WHERE User ='root';

FLUSH PRIVILEGES;

但不重置密码对于root,如何解决这个问题。







谢谢。

Mysql Client server is not opening.I have tried in cmd prompt it is displaying like "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)".For this i have tried the following procedure for reset the password.

C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe"
--defaults-file="C:\\Program Files\\MySQL\\MySQL Server 5.0\\my.ini"
--init-file=C:\\mysql-init.txt


mysql-init.txt
---------------
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
but it is not reset the password for root,how to resolve this problem.



Thank you.

此链接将 帮助你。