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 ]