MySQL 错误:cant't connect to MySQL server (10060)
来源:互联网 发布:visio软件安装包 编辑:程序博客网 时间:2024/05/22 08:00
1.网络不通
检查网络能不能ping通
2.防火墙设置
- 查看mysql 进程
- 查看3306端口 (当然,可以用在线扫描端口工具)
3.msyql的账户设置
mysql 账户是否允许远程链接。如果无法连接可以尝试以下方法:
mysql -u root -p mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;mysql> FLUSH PRIVIleGES;mysql> EXIT
也可以通过修改来实现远程:
mysql -u root -p mysql> use mysql; mysql> update user set host = '%' where user = 'root'; mysql> select host, user from user;
转载:http://database.51cto.com/art/201107/274565.htm(自己也有补充)
0 0
- MySQL 错误:cant't connect to MySQL server (10060)
- cant't connect to MySQL server on 'localhost' (10061) (发生系统错误1067)
- linux cant not connect to mysql server 10060 防火墙问题
- MySQL错误:Can't connect to MySQL server (10060)
- MySQL错误:Can't connect to MySQL server (10060)
- MySQL错误:Can't connect to MySQL server (10060)
- MySQL错误2003:Can't connect to MySQL server (10060)
- MySQL错误:Can't connect to MySQL server (10060)
- MySQL错误:Can't connect to MySQL server (10060)
- MySQL错误2003:Can't connect to MySQL server (10060)
- MySQL错误:Can't connect to MySQL server (10060)
- 连接MySQL错误:Can't connect to MySQL server (10060)
- MySQL错误2003:Can't connect to MySQL server (10060)
- mysql 出现2003- cant connect to MYSQL server on localhost 的错误
- MySQL错误号码2003 Cant connect to MySQL server localhost 0
- 2003 cant connect to MySQL server on 'localhost'(10061)
- error 2003 cant connect to mysql server on localhost 10061
- cant connect to mysql server on localhost(10038)
- 原生的上拉刷新 SwipeRefreshLayout和下拉加载
- H264相关
- gdb附加进程调试
- js数组
- Coding 孙宇聪:《人,技术与流程》
- MySQL 错误:cant't connect to MySQL server (10060)
- 【codevs1295】 N皇后问题
- spring source codes import to eclipse.
- Layout及SizeClass 大总结
- 对博客的说明
- Android Studio设置界面风格和字体大小
- matlab中的repmat函数
- POJ - 3278 Catch That Cow(BFS)
- Cocos2d-x源码啃食第一谈