解决linux下mysql密码错误的问题

[root@mytestlnx02 ~]# service mysql start

[root@mytestlnx02 ~]#

[root@mytestlnx02 ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

p.s.

mysql> update user set authentication_string=password('xxxxxxxx') where User='root';      

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('root_password') where User='root'' at line 1

[root@VM_0_8_centos ~]# grep 'temporary password' /var/log/mysqld.log

2018-09-26T04:25:54.927944Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: DN34N/=?aIfZ

[root@VM_0_8_centos ~]# mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

mysql> ALTER USER 'root' IDENTIFIED BY 'xxxxxxxxx'; 

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxxx';

Query OK, 0 rows affected (0.11 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

mysql> exit

Bye

重启服务

[root@VM_0_8_centos ~]# service mysqld stop

Redirecting to /bin/systemctl stop  mysqld.service

[root@VM_0_8_centos ~]# service mysqld start

Redirecting to /bin/systemctl start  mysqld.service