no comments yet
10
Nov
2019
mysql修改root用户密码
登录MySQL，
mysql> set password for root@localhost = password('新密码');
或者，update直接修改mysql库中的user表：
mysql> update user set password=password('888') where user='root';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 3 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)