mysql修改root密码

yunbo1
数据库
2026-09-16
168

1、如果知道root密码：

mysql -u root -p

输入密码

use mysql;

UPDATE user SET Password = PASSWORD(‘newpass‘) WHERE user = ‘root‘;

FLUSH PRIVILEGES;

quit;

2、如果不知道密码

service mysqld stop;

mysqld_safe --skip-grant-tables& mysql -u root mysql; UPDATE user SET password = PASSWORD ( "new password" ) WHERE user = ‘root‘ ; FLUSH PRIVILEGES ; password字段没有的话: update mysql.user set authentication_string=password(‘新密码‘) where user=‘root‘; FLUSH PRIVILEGES ;

上一篇
SQL Server捕获发生The query processor ran out of internal resources and could not produce a query plan...错误的SQL语句

下一篇
SQL SERVER 新增表、新增字段、修改字段判断表是否存在