设置mysql允许外网访问
设置mysql允许外网访问
需要连接或使用navicat
等查看同局域网主机的mysql
- 修改表
# 切换到mysql数据库
use mysql;
update user set host = '%' where user ='root';
select host, user from user;
# 使修改生效
flush privileges;
- 授权用户,你想root使用密码从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
# 如果你想允许用户root从ip为192.168.1.104的主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.3.114' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
- 如果目标为
Linux
系统,还要修改my.cnf
文件(/etc/mysql/my.cnf
)
[mysqld]
bind-address = 0.0.0.0 # 表示允许任何主机登陆MySQL
port=3306 # 表示MySQL运行端口为3306