开启远程服务:
登录mysql:
//赋予root用户所有权限,远程登录密码是123456
grant all privileges on *.* to 'root' @'%' identified by '';
flush privileges;
设置Linux的防火墙:
Linux(CentOs)防火墙默认拦截3306端口
/sbin/iptables -I INPUT -p tcp --dport -j ACCEPT
/etc/rc.d/init.d/iptables save
登录mysql:
//赋予root用户所有权限,远程登录密码是123456
grant all privileges on *.* to 'root' @'%' identified by '';
flush privileges;
Linux(CentOs)防火墙默认拦截3306端口
/sbin/iptables -I INPUT -p tcp --dport -j ACCEPT
/etc/rc.d/init.d/iptables save
该资源仅限VIP专享下载