root 密码丢失后的重新设置

/usr/local/mysql/bin/mysqld_safe --skip-grant-tables   &   

mysql> use mysql;
mysql> update user set password=PASSWORD("root") where user='root';

service mysqld stop;
service mysqld start;

/usr/local/mysql/bin/mysql -u root -p
posted @ 2014-09-25 10:26  新闻官  阅读(127)  评论(0编辑  收藏  举报