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)
网友评论