ERROR 2003 (HY000): Can't connect to MySQL server on '10.16.115.101' (111)
来源:互联网 发布:淘宝抽纸 编辑:程序博客网 时间:2024/05/17 01:50
ubuntu安装完mysql,使用apt-get命令安装的,默认是只允许本地访问的
root@idata1:~/software# mysql -uroot -p123456 -h10.16.115.101 -P3306
ERROR 2003 (HY000): Can't connect to MySQL server on '10.16.115.101' (111)
默认配置文件:
需要把bind-address注释掉
重启mysql服务
root@idata1:~/software# service mysql restart
mysql stop/waiting
mysql start/running, process 6738
测试连接
root@idata1:~/software# mysql -uroot -p123456 -h10.16.115.101 -P3306
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 141
Server version: 5.5.40-0ubuntu0.12.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
- ERROR 2003 (HY000): Can't connect to MySQL server on '10.16.115.101' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.114' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)
- 解决ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)
- 解决ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (111)
- 解决"ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.247.128' (111)"
- ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xxx' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on '223.3.46.114' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.10.210' (111) 解决方法
- Ubuntu ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.157' (111)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- Mysql启动报错:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题
- 今天是合璧儿开通博客的第3天,纪念一下
- webview相关
- Linux安装Android 开发 IDE之Android studio
- 天声人語 20141218
- 最大公约数、最小公倍数【模板】
- ERROR 2003 (HY000): Can't connect to MySQL server on '10.16.115.101' (111)
- max/min函数的用法
- 百度度地图总是提示key 验证出错! 请在 AndroidManifest.xml 文件中检查 key 设置解决办法
- 再探java基础——throw与throws
- Largest Rectangle in Histogram 直方图的最大正方形
- LeetCode(39) Combination Sum
- 如何编程在Revit里创建长度小于0.8mm的线
- Android Studio 1.0 导入第三方类库的方法
- codeforces 496C Removing Columns 贪心