adolfjap

mysql 忘记root

mysqld_safe --skip-grant-tables &

Then, login:

Code:

mysql -u root and you will be presented with the mysql> prompt.
Change your password like so:

Code:

use mysql;

Code:

update user set password=PASSWORD('NEWPASSWORD') where user='root';

Code:

flush privileges;