ERROR 2003 (HY000): Can’t connect to MySQL server on ’192.168.119.105′ (10061)
来源:互联网 发布:小米电视ktv软件 编辑:程序博客网 时间:2024/06/07 01:54
报错原因
- 默认mysql是无法远程连接,需要修改mysql.user的Host字段,默认Host字段的的数据都是’127.0.0.1′ 只能本地连接数据库,可以修改为’%',然后flush privileges;这样就可以远程访问了。如果这因为这个原因而无法远程访问的错误提示是:ERROR 1045 (28000): Access denied for user ‘yushan’@’192.168.119.102′ (using password: YES)。。
- 我在linux上安装了mysql,远程使用windows连接,结果提示:ERROR 2003 (HY000): Can’t connect to MySQL server on ’192.168.119.105′ (10061),找到这一句: bind-address = 127.0.0.1 ,将其注释掉,然后sudo service mysql restart 重启动。可以连接了!
- 如果是windows平台的mysql服务器无法被远程连接,可以禁用windows防火墙(net stop sharedaccess),mysql平台:/etc/init.d/iptables stop
- 确认/etc/mysql/my.cnf文件skip-networking 选项也被注释掉。skip-networking的作用是禁用tcp/ip连接,彻底杜绝mysql远程连接。现在新版本都没有开启skip-networking。
- ERROR 2003 (HY000): Can’t connect to MySQL server on ’192.168.119.105′ (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on
- ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.123' (10061)
- 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 'localhost' (10061)
- mysql长时间不用出现ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 解决 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- mysql 常见问题:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)
- mysql绿色版安装问题解决(ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061))
- MySQL 服务无法启动 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- MySQL错误ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)的解决
- ERROR 2003 (HY000):CAN’T CONNECT TO MYSQL SERVER ON ‘LOCALHOST’ (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 解决办法
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10061)
- linux下的php扩展
- SQL获取所有数据库名、表名、储存过程以及参数列表
- NSPredicate的用法 数组比较方法
- ASCII码表,码对照表,转换表
- Android-01
- ERROR 2003 (HY000): Can’t connect to MySQL server on ’192.168.119.105′ (10061)
- Tuxedo常见应用配置关注事项
- 织梦默认分页样式修改 解决分页列表显示,去掉li
- 2440裸机程序——跑马灯
- Android kernel和标准Linux Kernel的差异
- [转]JDK7新特性 监听文件系统的更改
- Java 中Iterator 、Vector、ArrayList、List 使用深入剖析
- 首写标记 待续
- 【C语言】18-变量类型