远程连接细节 处理
1.设置远程连接
1.1错误信息
bash: grant: 未找到命令...
原因:建立远程连接,需要登录MySQL才可以
解决步骤(输入命令):
- 登录MySQL
mysql -uroot -p123456
- 建立远程连接
rant all privileges on *.* to 'root' @'%' identified by '123456';
- 刷新
flush privileges;
2.MySQL客户端连接错误
2.1未关闭防火墙
解决方法:service iptables stop
2.2Linux报错
报错信息:Failed to stop iptables.service: Unit iptables.service not loaded.
解决方法:
- 执行一下命令
systemctl stop firewalld
systemctl mask firewalld
- 并且安装iptables-services:
yum install iptables-services
-
设置开机启动:
systemctl enable iptables systemctl stop iptables systemctl start iptables systemctl restart iptables systemctl reload iptables
- 保存设置:
service iptables save