Mysql默认root用户只能本地访问,不能远程连接管理mysql数据库,Linux如何开启mysql远程连接?设置步骤如下:
创建远程链接授权用户
1 | # 进入mysql操作命令 |
增加pibigstar用户授权访问,密码pibigstar
1 | GRANT ALL PRIVILEGES ON *.* TO pibigstar@localhost IDENTIFIED BY 'pibigstar' WITH GRANT OPTION; |
授与pibigstar用户从任何其它主机发起的访问(通配符%)
1 | GRANT ALL PRIVILEGES ON *.* TO pibigstar@"%" IDENTIFIED BY 'pibigstar' WITH GRANT OPTION; |
上面的执性完成之后,基本上就可以通过用户名 pibigstar 密码 pibigstar 访问了,如果还是不行,查看下面方式来解决
设置防火墙允许3306端口
1 | vi /etc/sysconfig/IPtables |
添加
1 | -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT |
注意:
添加在-A RH-Firewall-1-INPUT -j REJECT –reject-with icmp-host-prohibited
之前,否则可能导致规则不生效
重启防火墙
1 | service iptables restart |
远程访问mysql速度很慢的解决方法
修改/etc/my.cnf或my.ini
[mysqld]下添加
1 | skip-name-resolve |