当前位置 : 主页 > 编程语言 > java >

centos 6.9 下忘记mysql密码

来源:互联网 收集:自由互联 发布时间:2022-08-10
忘记密码: service mysqld stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networking # mysql -u root use mysql; mysql update user set password=password("newpassword") where user='root'; mysql flush privileges; mysql quit servi
忘记密码:
service mysqld stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root
use mysql;
mysql> update user set password=password("newpassword") where user='root';
mysql> flush privileges;
mysql> quit
service mysqld restart
# mysql -uroot -p
enter password: <输入新设的密码newpassword>
mysql>
网友评论