mysql 密码

一、重置密码

启动 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';