主机连接虚拟机MySQL报错:Can't connect to Mysql server on '192.168.33.10' (10061 "Unknown error")
来源:互联网 发布:JavaScript match(src) 编辑:程序博客网 时间:2024/05/21 22:44
之前写过一篇文章,是关于主机连接虚拟机时报无法连接的文章(主机连接虚拟机MySQL报错:Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server)。是由于虚拟机MySQL服务器没有授权远程用户登录导致的。
今天遇到一个类似的问题,报错:Can't connect to Mysql server on '192.168.33.10' (10061 "Unknown error"),是由于虚拟机MySQL数据库绑定的主机名限定为本机导致的。
解决办法:
1.按照《主机连接虚拟机MySQL报错:Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server》这篇文章的步骤给远程机器授权。
2.修改MySQL配置文件/etc/mysql/my.conf,将
bind-address = 127.0.0.1
修改为
bind-address = 0.0.0.0
重启MySQL服务器,回到主机重新登录虚拟机MySQL,问题解决!
阅读全文
0 0
- 主机连接虚拟机MySQL报错:Can't connect to Mysql server on '192.168.33.10' (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)
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061 "Unknown error")
- 数据库连接时 报错 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
- Navicat连接远程mysql数据库error报错2003 can't connect to mysql server on 10038解决办法
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- Mysql 连接报错 Can't connect to MySQL server on “127.0.0.1” (61)
- Error: Can't connect to MySQL server on 'localhost' (10061)
- Error: Can't connect to MySQL server on 'localhost' (10061)
- Mysql 报错:ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xxx.xxx' (111)
- python MySQLdb连接MySQL数据库报错(2003, "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'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'的问题
- ERROR 2003 Can’t connect to MySQL server on ‘localhost’
- Java经典设计模式之五大创建型模式(附实例和详解)
- 回顾大一·C语言编程1.3
- Firefly-RK3399斑块检测
- 第四周项目6——循环双链表应用
- 关于小程序上传 java服务端的接收
- 主机连接虚拟机MySQL报错:Can't connect to Mysql server on '192.168.33.10' (10061 "Unknown error")
- My Tableau 公式
- 闭包之Closure
- 75个顶级开源安全应用
- 弹出框与图片轮播
- WebApp开发之Cordova安装教程
- cs229 支持向量机小议
- CSS元素排列(居中)问题
- dubbo是如何“插入”到spring框架中的