远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
来源:互联网 发布:linux find mtime 0 编辑:程序博客网 时间:2024/06/05 06:46
环境:
系统版本: CentOS release 6.5 (Final)
数据库版本: 5.1.73
问题描述:
使用客户端远程登录连接基于CentOS 6.5服务器上的Mysql,报错:Can't connect to MySQL server on 'XXX' (13)
解决方法:
通常情况下,可以进行如下设置
1. 进入MySQL的控制台
# mysql -u root -p
2. 在MySQL的控制台中输入如下命令
mysql> grant all privileges on *.* to 'root'@'your-host-ip' identified by 'your-mysql-password' with grant option;
mysql> flush privileges;
mysql> exit
3. 重启Mysql
# /etc/init.d/mysqld restart
至此,不出意外已经完成修改,并验证通过。
但是如果此时还是出现Can't connect to MySQL server on 'XXX' (13)的错误提示,可以尝试如下方法:
1. 查看httpd_can_network_connect的值是否为off(例如:httpd_can_network_connect --> off)
# getsebool -a | grep httpd
2. 修改httpd_can_network_connect的值为on
# setsebool httpd_can_network_connect 1
3. 重新验证httpd_can_network_connect
# getsebool -a | grep httpd
4. 重启http
# /etc/init.d/httpd restart
5. 进入客户端重启登录验证
此时错误信息变为:Access denied for user 'root'@'your-host-ip'(usring password:YES)
6. 进入Mysql控制台重新GRANT(如上)
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- MySQL(CentOS中)远程连接报错:Can't connect to MySQL server on 'your-host-ip'
- Can't connect to MySQL server on 'xxx' (13)
- Can't connect to MySQL server on 'XXX' (13)
- Navicat连接远程mysql数据库error报错2003 can't connect to mysql server on 10038解决办法
- 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'的问题
- Mysql 连接报错 Can't connect to MySQL server on “127.0.0.1” (61)
- Mysql 报错:ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xxx.xxx' (111)
- Can't connect to Mysql server on xxx (10038)
- 转:navicat远程连接mysql,2003 can't connect to mysql server on 10038
- navicat远程连接mysql,2003 can't connect to mysql server on 10038
- Can't connect to MySQL server on '*' (13) 的解决方案
- MySQL远程访问报错ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'(111)
- 最近win7下右键弹出菜单很慢,现已解决
- Linux 上安装编译 PIL 1.1.6
- 最近win7下右键弹出菜单很慢,现已解决
- uwsgi invalid request block size: 的解决办法
- 公司笔记本电脑配置
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- windows系统上面如何后台执行程序
- python内存不释放原理
- MySQL单列索引和组合索引的区别
- 禁止批处理中的某一条命令回显结果(批处理中的sleep)
- 大端与小端
- #!/usr/bin/env python 和 #!/usr/bin/python 的区别
- linux下查询http连接的服务器信息
- python开发工具 Wing IDE 简单配置以及中文乱码问题解决