下面是关于密码重置的命令,转自百度经验:https://jingyan.baidu.com/article/0320e2c198ad5f1b87507bc8.html
方法1: 用SET PASSWORD命令
1
2
|
MySQL -u root
mysql>
SET
PASSWORD
FOR
'root'
@
'localhost'
=
PASSWORD
(
'newpass'
);
|
方法2:用mysqladmin
1
|
mysqladmin -u root
password
"newpass"
|
如果root已经设置过密码,采用如下方法
1
|
mysqladmin -u root
password
oldpass
"newpass"
|
方法3: 用UPDATE直接编辑user表
1
2
3
4
|
mysql -u root
mysql> use mysql;
mysql>
UPDATE
user
SET
Password
=
PASSWORD
(
'newpass'
)
WHERE
user
=
'root'
;
mysql> FLUSH
PRIVILEGES
;
|
在丢失root密码的时候,可以这样
1
2
3
4
|
mysqld_safe
--skip-grant-tables&
mysql -u root mysql
mysql>
UPDATE
user
SET
password
=
PASSWORD
(
"new password"
)
WHERE
user
=
'root'
;
mysql> FLUSH
PRIVILEGES
;
|