linux下修改mysql root密码

时间:2022-05-19 16:17:34
1.关闭mysql
# service mysqld stop
2.屏蔽权限
# mysqld_safe --skip-grant-table
3.新开起一个终端输入
# mysql -u root mysql
mysql>  UPDATE user SET Password=PASSWORD('newpassword') where USER='root'
mysql> FLUSH PRIVILEGES;//记得要这句话,否则如果关闭先前的终端,又会出现原来的错误
mysql> \q