Mysql开启远程连接

方式1：改表

use  mysql;
update user set host = '%' where user = 'root'; # root为用户名

方式2: 修改权限

# 【必选步骤】
use  mysql;

# 赋予任何主机访问数据的权限【三选一】
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION; # root为用户名

# 想myuser使用mypassword从任何主机连接到mysql服务器【三选一】
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

# 想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器，并使用mypassword作为密码【三选一】
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.6'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

# 使修改生效【必选】
FLUSH PRIVILEGES;