MySQL5.0.45_20080923_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';