mysql5.7.20 远程连接_mysql5.7开启远程连接

Ubuntu16.04

1登录到mysql中，为root进行远程访问的授权，所以主机都可以链接

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

修改生效

mysql>FLUSH PRIVILEGES

切换到 mysql DB

mysql> use mysql;

Database changed

查看现有用户,密码及允许连接的主机

mysql> select user,host from user;

+------------------+-----------+

| user | host |

+------------------+-----------+

| root | % |

| debian-sys-maint | localhost |

| mysql.sys | localhost |

| root | localhost |

+------------------+-----------+

2、进入/etc/mysql/mysql.conf.d 目录下的 mysqld.cnf 文件中需要把下面以上注释掉，使所以主机都可以链接

bind-address = 127.0.0.1