最近我的ubuntu系统sudo装的数据库出现问题,迫于无奈重装,重装启动后用mysql命令客户端连接,出现如下提示:
- [LING mysql]$ <span style="">mysql -u root -p</span>
-
- Enter password:
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
我的my.cnf如下:
- [mysqld]
- datadir=/var/lib/mysql
- <span style="color: #ff0000; font-size: x-small;">socket=/var/lib/mysql/mysql.sock</span>
-
- user=mysql
-
-
- old_passwords=1
-
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
- port=3307
进入/var/lib/mysql下,发现mysql.sock存在,但/var/run/mysqld下没有mysqld.sock,灵机一动,可以通过软链接的方式使用/var/lib/mysql/mysql.sock:
- [ROOT mysqld]$ <span style="">ln -s /var/lib/mysql/mysql.sock /var/run/mysqld/mysqld.sock</span>
-
- [ROOT mysqld]$ mysqld_safe --log-error=/var/lib/mysql/error.log &
做链接并启动mysql,查看error.log,如下:
- [ROOT mysql]$ <span style="color: #ff0000;">more error.log </span>
-
- InnoDB: The log sequence number in ibdata files does not match
- InnoDB: the log sequence number in the ib_logfiles!
- 100313 10:48:12 InnoDB: Database was not shut down normally!
- InnoDB: Starting crash recovery.
- InnoDB: Reading tablespace information from the .ibd files...
- InnoDB: Restoring possible half-written data pages from the doublewrite
- InnoDB: buffer...
- 100313 10:48:12 InnoDB: Started; log sequence number 0 43655
- 100313 10:48:12 [Note] /usr/sbin/mysqld: ready for connections.
- Version: '5.0.51a-3ubuntu5.5' socket: '/var/lib/mysql/mysql.sock' port: 3307 (Ubuntu)
- [ROOT mysql]$
重新链接,成功了!
分享到:
相关推荐
ERROR 2002: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111) 解决办法: /usr/local/mysql/bin/mysqladmin -u root > -S /var/lib/mysql/mysql.sock password 'your.passwd' ...
mysql 支持 socket 和 TCP/IP 连接。那么 mysql.sock 这个文件有什么用呢?本文给大家介绍的非常详细,需要的朋友参考下吧
在安装好了MySQL之后,使用了新的配置文件后,MySQL服务器可以成功启动,但在登陆的时候出现了ERROR 2002 (HY000): Can’t connect to local MySQL server through socket,即无法通过socket连接到mysql服务器,同时...
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 的异常。是用dmg直接安装的以为安装包又出现了奇奇怪怪的错误,正欲卸载该版本时找到了我的问题的关键。 解决...
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 出现问题原因: 有可能是 my.cnf 配置文件中设置了 [mysqld] 的参数 socket ,而没有设置[client]的参数socket ...
~$ mysqlERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)网上好多的解决办法,可是每个人的实际情况不同,我也是把上面所有人的方法实验了一个遍,...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
今天小编就为大家分享一篇关于Can't connect to local MySQL through socket '/tmp/mysql.sock'解决方法,小编觉得内容挺不错的,现在分享给大家,具有很好的参考价值,需要的朋友一起跟随小编来看看吧
?php $link=mysql_connect(‘localhost’,’root’,... 运行后报错 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ 但在 命令行中能进入mysql [root@localhost local]# mysql -u root -p E
主要介绍了MySQL错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket,需要的朋友可以参考下
php 不能连接数据库 php error Can't connect to local MySQL server through socket '/tmp/mysql.sock'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock' (2) 排查过程 1、先查看 /etc/rc.d/init.d/mysqld status 看看mysql是否已经启动. 另外看看是不是权限问题...
最近在linux上装Aphace... can't connect to local MySQL server through socket 'var/run/mysqld/mysqld.sock' 这个把我弄得几近崩溃,我在网上查找了很多的解决办法,大概有几种解决方案: 1.权限问题 2.修改/
3、Can’t connect to local MySQL server through socket ‘/Data/mydata/mysql.sock’ socket文件目录不对应导致的问题 4、今天要说的就是 没有打开only_full_group_by Cause:...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 如果说出现这个一般就是因为MySQL没有起来 [root@localhost ~]# mysql -uroot -p ERROR 1045 (28000):...
提示:Can’t connect to local MySQL server through socket… 检查环境正常 以为是数据库没有启动,于是查看一下进程,MySQL在进程里,重启了一下MySQL. 使用mysql -u root -p 可以进入MySQL操作
,命令行链接数据库时也报 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2),网上找了一些资料,居然都是相互抄袭的,并且并没有解决问题。然后自己摸索了一下,问题就解决...
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 分析:使用mysql –verbose –help进行分析,才发现原来port和socket对应的值都为0或者为空,也就是默认参数都...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) 2、故障分析 查看mysql实例的状态 [root@localhost scripts]# netstat -ntlp | grep 3306 tcp 0 0 :
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’