阿里云服务器安装mysql远程工具连接报Can't connect to MySQL server on 'X.X.X.X'(10038)
来源:互联网 发布:中国禁枪怕被推翻 知乎 编辑:程序博客网 时间:2024/06/05 05:20
刚买的阿里云centos7.4的云服务器,mysql安装好后,将配置文件my.cnf中的bind-address注释掉,设置了防火墙对外端口3306,使用telnet 10.10.10.10 3306还是连接失败,最后找到问题症结是阿里云的云服务器后台里面安全组规则设置的问题,处理如下图:
上面三步后如果出现拒绝非本地IP访问则grant授权即可,以上ok圆满解决问题。
阅读全文
1 0
- 阿里云服务器安装mysql远程工具连接报Can't connect to MySQL server on 'X.X.X.X'(10038)
- 2003 - Can't connect to MySQL server on 'x.x.x.x' (10038)
- 使用navicat连接mysql 报错:2003-Can't comment to Mysql server on '192.168.X.X'(10038)
- 一个无法访问mysql的错误: ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (111)
- 关于大并发mysql连接引起数据库错误OperationalError: (2003, "Can't connect to MySQL server on 'x.x.x.x (99)")分析
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- Navicat连接远程mysql数据库error报错2003 can't connect to mysql server on 10038解决办法
- MySQL远程连接:Host 'x' is not allowed to connect to this MySQL server
- 转:navicat远程连接mysql,2003 can't connect to mysql server on 10038
- navicat远程连接mysql,2003 can't connect to mysql server on 10038
- MySQL(CentOS中)远程连接报错:Can't connect to MySQL server on 'your-host-ip'
- aws linux服务器,ubuntu,远程连接MySQL,ERROR 2003 (HY000): Can't connect to MySQL server on
- can't connect mysql server on '...' 10060 连接远程mysql服务失败报错
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- MySQL远程连接ERROR 2003 (HY000):Can\'t connect to MySQL server on\'XXXXX\'的问题
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- qt+opencv图像在控件上的显示 槽和信号的定义.
- ubuntu下运行第一个opencv程序
- 会话管理
- masonry
- unityVR全景视频制作
- 阿里云服务器安装mysql远程工具连接报Can't connect to MySQL server on 'X.X.X.X'(10038)
- DB2列转行,listagg的使用方法
- windows下建立PHP开发环境
- JSTL标签,EL表达式,OGNL表达式,struts2标签 汇总
- JavaMail发送邮件工具类(不带附件)
- 利用html和css做【雷达】效果
- 云计算参考资料
- [Unity][Calendar]制作日历的思路
- python对mysql的操作