Mysql找回丢失密码
(先进入root权限):
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root
mysql> update mysql.user set password=password("newpassword") where user='root' and host="localhost";
mysql> flush privileges;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
enter password: <输入新设的密码newpassword>
posted on 2018-03-04 13:14 William126 阅读(119) 评论(0) 编辑 收藏 举报