Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061),错误代码2003
来源:互联网 发布:淘宝怎么再次申请退款 编辑:程序博客网 时间:2024/05/18 06:25
用SQKyogt等远程连接服务器上mysql出现问题
先看下错误提示错误代码2003Can’t connect to MySQL server on ‘ip’ 经过一番百度后,解决了问题。在此记录下解决方法
1. 确定登陆账号密码没有错误,在服务器上验证没有错
2. 要确保mysql支持别的机器访问,root登陆mysql,需要在user表中设置
use mysql;select host,user,password from user; delete from user where user=''; --要删除 user为空的用户delete from user where user='';
–为root用户设置密码,这里用到了一个函数 PASSWORD()他可以将输入的明文密码转换为加密码格式
update user set password=PASSWORD('123456') where user='root';
--刷新权限flush privileges;--为其他客户端开启连接权限 如果是hive和mysql在同一台服务器上则不需要授权grant all privileges on *.* to 'root'@'%' identified by '123456'; -- 可以把 %改成IP,则授权固定IP
3. 在/ect/my.cnf或者是在/ect/mysql/my.cnf修改配置
有可能因为 配置了skip_networking或者bind_address,只允许本地socket连接
知识说明: 这使用MySQL只能通过本机Socket连接(socket连接也是本地连接的默认方式),放弃对TCP/IP的监听
我的里面用设置skip_networking,所以将skip_networking注释,保存退出。
#service mysqld restart 重启mysql服务。问题解决
0 0
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061),错误代码2003
- 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 'xxx.xxx.xx.xxx' (111)
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (3)
- Can't connect to MySQL server on 'xxx' (13)
- Can't connect to MySQL server on 'XXX' (13)
- Can't connect to Mysql server on xxx (10038)
- Mysql error number 2003 can't connect to mysql server on XXX(10061)
- Mysql 报错:ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xxx.xxx' (111)
- 2003 cant connect to MySQL server on 'XXX.XXX.XXX.XXX'
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX' (13)
- SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX'
- SQLSTATE[HY000] [2003] Can\'t connect to MySQL server on \'XXX\' (13)
- php程序mysql Can't connect to MySQL server on 'XXX' (13)错误解决办法
- 远程连接CentOS的MySQL报错:Can't connect to MySQL server on 'XXX' (13)
- 【linux】Can't connect to MySQL server on 'XXX' (13)问题解决方式
- MySQL: 2003 can't connect to mysql service on 'xxx' (10060)
- Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL server
- ngrok内网穿透访问本地项目
- 安装Android Studio162.3871768
- Java中String、StringBuilder以及StringBuffer
- Android设计模式(二十二)-外观模式
- Find them, Catch them(带权值的并查集)
- Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10061),错误代码2003
- 【C语言】统计一个数中1的个数(移位操作符)
- RecyclerView 拖拽,滑动
- MySQL 储存过程-原理、语法、函数详细说明
- 网络基础(一):传输层、数据链路层工作原理
- BZOJ 2127 happiness
- 联想小新v2000bigger安装黑苹果
- Faster R-CNN: Towards Real-Time Object Detection with Region Proposal Networks(更快的RCNN:通过区域提议网络实现实时
- 计算 1 到 N 之间 有多少个 1