mysql> select host,password,user from mysql.user;
+----------------------+-------------------------------------------+------+
| host | password | user |
+----------------------+-------------------------------------------+------+
| localhost | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | root |
| vm\_215\_212\_centos | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | root |
| 127.0.0.1 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | root |
| ::1 | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | root |
| % | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | root |
+----------------------+-------------------------------------------+------+
修改用户名密码
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"localhost" IDENTIFIED BY "用户密码";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
navicat 远程连接数据出现下面的错误 需要添加如下命令:
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "远程连接密码";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)