mysql> update mysql.user set password=PASSWORD('root')where User='root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0

mysql> Ctrl-C -- exit!
Aborted

在这里插入图片描述
然后重启mysql

/etc/init.d/mysqld restart
[root@iz2ze2xn7t0ti53gx57cgcz ~]#  /etc/init.d/mysqld restart
Restarting mysqld (via systemctl):                         [  OK  ]
Logo

更多推荐