mysql reset root user password.

[admin]

Stop mysql and start mysqld like this:

Code: Select all

/usr/sbin/mysqld --skip-grant-tables --skip-networking

connect to mysql reset root user password:

Code: Select all

user mysql;
UPDATE user SET Password = PASSWORD('abcd')    WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
exit;

stop mysqld and start with startup script.