How to reset MYSQL "root" password :
Stop mysqld and restart it with the --skip-grant-tables --user=root options
(Windows users omit the --user=root portion).
Connect to the mysqld server with this command:
shell> mysql -u root
Issue the following statements in the mysql client:
mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;
No comments:
Post a Comment