2003——can't connect to mysql server on '***'(10061)
来源:互联网 发布:c语言数组结束符 编辑:程序博客网 时间:2024/06/16 09:38
本地navicat连接虚拟机中Linux的mysql提示2003——can't connect to mysql server on '***'(10061)
首先给mysql中给root赋予访问权限
mysql -uroot -p0127//登录mysql
grant all privileges on *.* to 'root'@'%' with grant option//赋予任何主机访问数据的权限
flush privileges //修改生效
exit //退出
service mysqld restart //重启mysql服务
发现并没有什么卵用继续搜:
修改my.ini文件,(Linux下为my.cnf)
把bind-address = 127.0.0.1
改成bind-address = 0.0.0.0
大功告成!
0 0
- Navicat连接mysql出现2003——can't connect to mysql server on localhost(10061)
- #2003: Can't connect to MySQL server on 'localhost' (10061)
- 2003 - can‘t connect to mysql server on localhost 10061
- 2003 - Can't connect to MySQL server on 'localhost' (10061)
- 2003 -can't connect to mysql server on ‘localhost'(10061)
- 2003 can't connect to MySql Server on 'localhost' (10061)
- 2003 - Can't connect to MySQL server on 'localhost' (10061)
- 2003 - Can't connect to MySQL server on‘localhost' (10061).
- 2003-can't connect to mysql server on 'localhost'(10061)
- 2003 - Can't connect to MySql server on 'localhost'(10061)
- 2003-Can't connect to MySQL server on 'localhost'(10061)
- 2003——can't connect to mysql server on '***'(10061)
- Can't connect to MySQL server on
- Mysql:Can't connect to MySQL server on ‘localhost' (10061)
- MySql -- 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' (10061)解决方法
- Error: Can't connect to MySQL server on 'localhost' (10061)
- matlab添加新工具出现与原matlab函数冲突
- 随堂笔记
- 看AppCan移动开发平台社区如何华丽转变
- 详解JAVA内部类
- fir.im Weekly - 30 天从 0 开始学 Swift
- 2003——can't connect to mysql server on '***'(10061)
- MKNetworkKit的介绍和应用
- java增删改查JDBC封装类
- 为什么函数对象在for_each中会析构三次
- Oracle数据库update触发器
- get_user_pages的意义
- HttpServletRequest
- 解决pod install/update时出现的一些警告
- mysql 5.6 打开慢查询