一、重置密码
启动 MySQL :bin/safe_mysqld --skip-grant-tables &
>use mysql
>update user set password=password("new_pass") where user="root";
>flush privileges;
重新杀 MySQL
二、修改密码
/usr/bin/safe_mysqld --skip-grant-tables &
./mysqladmin -u root password ‘new_password’
mysql>UPDATE user SET password=PASSWORD(‘new_password’) WHERE user=’root’;
mysql>FLUSH PRIVILEGES;
SET PASSWORD FOR root=PASSWORD(’new_password’);
GRANT USAGE ON *.* TO root@'localhost' IDENTIFIED BY '111111';