mysql 8.0 远程连接数据库

mysql 8.0 远程连接数据库

前提

• 本地安装mysql数据库
• 本地和远程网络是通畅的。（可以使用 cmd命令 ping ip地址（eg:ping 192.168.1.123）表示通路）
  

mysql 修改密码

alter user 'root'@'localhost' identified with mysql_native_password by '123456'

刷新权限

flush privileges,

mysql数据库授权

mysql> use mysql
Database changed
mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

果然，发现root用户的访问权限是localhost,需要修改host为%，输入命令：

update user set host='%' where user='root';

flush privileges;

结果如下：

mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 
再次查询修改后结果，OK。结果如下：
 
mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | root             |
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
+-----------+------------------+
4 rows in set (0.00 sec)

mysql远程登录

使用授权的账号电脑远程登录mysql 8.0 ；