1,登录mysql

使用root用户身份登录连接 mysql

mysql -uroot -p

2，修改数据库密码

update mysql.user set authentication_string=password('aa123456') where user='root' and host='localhost';

这里设置新密码为aa123456，用户为root
注意：这里密码最好不能是纯数字

mysql> update mysql.user set authentication_string=password('aa123456') where user='root' and host='localhost';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

3, 刷新权限表

flush privileges;

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

退出登录，重新登录

输入 exit退出mysql

重新登录mysql -uroot -p 使用新密码

4， 查看有几个 数据库

show databases;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| fairpushserverdb   |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

5，查询密码 plugin 类型

select Host,User,plugin from mysql.user;

mysql> select Host,User,plugin from mysql.user;
+-----------+---------------+-----------------------+
| Host      | User          | plugin                |
+-----------+---------------+-----------------------+
| localhost | root          | mysql_native_password |
| localhost | mysql.session | mysql_native_password |
| localhost | mysql.sys     | mysql_native_password |
+-----------+---------------+-----------------------+
3 rows in set (0.00 sec)