ubuntu下连接mysql时报错:Lost connection to MySQL server at 'reading initial communication packet', system
来源:互联网 发布:oracle数据库建表空间 编辑:程序博客网 时间:2024/05/17 02:34
使用终端运行mysql,报出如下错误:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
百度之,发现是由于mysqld.sock文件被误删之后导致的。
解决方法如下:
以root用户重建授权表
#usr/local/bin/mysql_install_db //以root重建授权表
或者是以mysql的身份:
#su mysql
$/usr/local/bin/mysql_install_db //重建授权表
然后就会出现如下的信息:
$/usr/local/bin/mysqld_safe & //mysqld_safe & 启动mysql的守护进程
$/usr/local/bin/mysql //测试
mysq>bye;
至此, ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 的问题解决.
0 0
- ubuntu下连接mysql时报错:Lost connection to MySQL server at 'reading initial communication packet', system
- 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
- 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', system error: 0
- Lost connection to MySQL server at ‘reading initial communication packet’, system error: 111
- lost connection to mysql server at 'reading initial communication packet',system error:2
- 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 et system error:0
- 遇见Lost connection to MySQL server at 'reading initial communication packet',system error:0的解决办法
- mysql报错:Lost connection to MySQL server at 'reading initial communication packet'
- 有关Mysql出现Lost connection to MySQL server at 'reading initial communication packet', system error: 0的一个解决方案
- 打开MYSQL时出现闪退lost connection to mysql server at 'reading initial communication packet' system error
- MySQL error: 2013, “Lost connection to MySQL server at 'reading initial communication packet', syste
- 2013 Lost connection to MySQL server at 'handshake: reading initial communication packet'
- Lost connection to MySQL server at 'reading initial communication packet' 错误解决
- SVN Application
- hasOwnProperty方法的使用
- MD5的加密和解密(总结)
- NodeJS应用设成随系统启动而自动运行
- 数据结构之进阶排序(希尔排序、快速排序、归并排序)
- ubuntu下连接mysql时报错:Lost connection to MySQL server at 'reading initial communication packet', system
- Timer中schuduel方法的使用
- 在Ubuntu 12.04.2 LTS上安装OpenGrok浏览Android源码
- u-boot 分析:Makefile详解
- 对象变量比较
- 利用DHT网络原理制作bt采集蜘蛛
- spring batch(一):基础部分
- 管道 pipe 半双工/全双工
- Android Wear Preview- 归档通知(Stacking Notifications)