mysql reading initial communication packet
来源:互联网 发布:电脑usb端口无法识别 编辑:程序博客网 时间:2024/06/06 00:35
刚解决了一个小问题,在此记录一下。
测试服务器上的mysql,当我在本地使用工具去连接它的时候,报错:Lost connection to MySQL server at 'reading initial communication packet'
我首先想到的是要在服务器上给所有IP授权,于是在服务器上使用命令登录mysql,并执行:
grant all privileges on dbname.* to 'username'@'%' identified by 'passed'
其中,%号表示允许所以IP访问。
到本地试着连接一下还是不行。
然后我继续做其它尝试的时候,在错误提示了看到一句话:请确定mysql中是否去掉了skip-networking的设置。我打开mysql的配置文件:
vi /etc/mysql/my.cnf
注意到下面的内容:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1 # Instead of skip-networking the default is now to listen only on
原来是这里做了绑定,我把bind-address注释起来。就可以了!
- mysql reading initial communication packet
- reading initial communication packet
- MySQL _Windows 环境下 MySQL:reading initial communication packet 问题解决
- Lost connection to MySQL server at ‘reading initial communication packet
- Lost connection to MySQL server at ‘reading initial communication packet
- mysql报错:Lost connection to MySQL server at 'reading initial communication packet'
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0 mysql远程连接
- 连接mysql出现Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- MySQL error: 2013, “Lost connection to MySQL server at 'reading initial communication packet', syste
- MySql Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111
- MySQL连接出现错误 'reading initial communication packet', system error: 0
- lost connection to mysql server at 'reading initial communication packet',system error:2
- 2013 Lost connection to MySQL server at 'handshake: reading initial communication packet'
- 2013 - Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
- Lost connection to MySQL server at ‘reading initial communication packet', system error: 0
- Lost connection to MySQL server at 'reading initial communication packet' 错误解决
- Lost connection to MySQL server at 'reading initial communication packet et system error:0
- 笔试题:创建一个单链表,结点包含学生的学号,姓名,性别,年龄信息.写几个程序,实现按学生学号插入,查询,删除等操作.
- seleniumIDE+firebug+seleniumRC
- C#实现程序启动唯一实例的一种方法
- mastudio 从晚上获取表格
- Cocos2d-x初入学堂(3)-->TexturePacker非常棒的图像处理工具
- mysql reading initial communication packet
- mastudio 下载附件
- 悲喜一瞬间,此悲伤非彼悲伤:伤感日志
- 結合 Selenium RC
- Autogrow of file '******' in database '******' was cancelled by user or timed out after ****** milli
- 用Visual studio11在Windows8上开发驱动实现内存填0杀进程
- BS开发需要注意的细节
- Java 单例模式详解
- 常见的手机屏幕分辨率