进入mysql 数据库输入
mysql> update mysql.user set authentication_string=password('XXXXXX') where user='root' and Host = 'localhost'
报错
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决办法:
mysql> alter user user() identified by "123456";
Query OK, 0 rows affected (0.00 sec)