远程操作mysql的数据库是非常方便的,比如调整数据表字段,数据的备份,导入等操作。对应维护站点非常方便。首先设置mysql可以被远程ip访问的权限,其次,服务器也要打开3306端口,供远程ip访问。这样才能远程操作数据库。
1,设置权限
use mysql;
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’IDENTIFIED BY ‘xxxxxxxx’ WITH GRANT OPTION;
flush privileges;
重启服务
service mysqld stop;
service mysqld start;
2,打开端口
firewall–cmd —zone=public —add–port=3306/tcp —permanent
firewall-cmd –reload
systemctl stop firewalld
systemctl start firewalld