Can't connect to MySQL server on '' (10060)
来源:互联网 发布:mac 屏幕分辨率设置 编辑:程序博客网 时间:2024/05/16 19:31
客户端远程连接部署在linux服务器的mysql出现以上错误,总大概分为以下3点
主要有3个原因:
1、检查网络是否可以ping通,这个就不说了。
2、mysql授权表里没有远程机器的权限
方法一、本地登入mysql,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,将"localhost"改为"%"
#mysql -u root -proot
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
方法二、直接授权(推荐)
从任何主机上使用root用户,密码:youpassword(你的root密码)连接到mysql服务器:
grant all privileges on *.* to 'root'@'%' identified by '登陆密码'
flush privileges;3、防火墙禁止3306端口,以iptable为例
vi /etc/sysconfig/iptables
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306-j ACCEPT
service iptables restart
iptables设置
1) 重启后生效
开启: chkconfig iptables on
关闭: chkconfig iptables off
2) 即时生效,重启后失效
开启: service iptables start
关闭: service iptables stop
0 0
- Can't connect to MySQL server on
- Can't connect to MySQL server on '' (10060)
- Can't connect to MySQL server on IP(10060)
- Can't connect to MySQL server on '' (10060)
- Mysql:Can't connect to MySQL server on ‘localhost' (10061)
- [mysql] Can't connect to mysql server on '127.0.0.1'
- MySql -- Can't connect to MySQL server on 'localhost' (10061)
- MySQL异常:Can't connect to MySQL server on 'localhost'
- Can't connect to MySQL server (10060)
- Can't connect to MySQL server (10060)
- Can't connect to MySQL server on 'localhost' (10048)
- Can't connect to MySQL server on 'localhost' (10055)
- #2003: Can't connect to MySQL server on 'localhost' (10061)
- Can't connect to MySQL server on 'localhost' (10061)问题解决
- 解决Can't connect to MySQL server on 'localhost' (10048)
- Can't connect to MySQL server on 'localhost' (10061)解决方法
- Can't connect to MySQL server on 'localhost' 解决
- Error: Can't connect to MySQL server on 'localhost' (10061)
- 如何保证请求的数据是最新的?
- C#学习视频分享与开发技术QQ交流群
- css通过特殊性解决样式冲突
- InternetReadFile 下载文件
- 正确使用#include和前置声明(forward declaration)
- Can't connect to MySQL server on '' (10060)
- 阿里云win2008企业版镜像搭建ftp服务
- Oracle查询前10条记录及分页查询(第5条到第10记录)
- 音频视频处理之一;常见的是视频格式介绍
- 导出EXCEL(JAVA)
- 重新启动的老式喷墨打印机
- 浅谈Android布局
- [资料分享]迅为4412开发板接口详解(一)
- 金蝶账套升级