如何在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.