解决了Cant connect to local MySQL server through socket 问题

 

Fedora8启动mysql报错：

ERROR2002(HY000):Can’tconnecttolocalMySQLserverthroughsocket‘/var/lib/mysql/mysql.sock’(2)

1、先查看/etc/rc.d/init.d/mysqldstatus看看mysql是否已经启动.
另外看看是不是权限问题.

2、确定你的mysql.sock是不是在那个位置，
mysql-u你的mysql用户名-p-S/var/lib/mysql/mysql.sock

3、试试：servicemysqldstart

4、如果是权限问题，则先改变权限#chown-Rmysql:mysql/var/lib/mysql

[root@localhost~]#/etc/init.d/mysqldstart
启动MySQL：[确定]
[root@localhost~]#mysql-uroot-p

ERROR2002(HY000):Can''tconnecttolocalMySQLserverthroughsocket''/var/lib/mysql/mysql.sock''(2)
原因是，/var/lib/mysql的访问权限问题。

shell>chown-Rmysql:mysql/var/lib/mysql

接着启动服务器

shell>/etc/init.d/mysqlstart

服务器正常启动后察看/var/lib/mysql自动生成mysql.sock文件。

但是我的问题仍然没有得到解决。

问题终于解决：
方法：修改/etc/my.conf:
[mysqld]
datadir=/usr/local/mysql/data
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

Ifthereisnotcurrentlyasectioncalled[client],addoneatthebottomofthefileandcopythesocket=lineunderthe[mysqld]sectionsuchas:

[client]
socket=/var/lib/mysql/mysql.sock

发现依旧如此，运行/etc/init.d/mysqlstart报错：StartingMySQLCouldn''tfindMySQLmanagerorserver
是mysqld服务没启，运行/usr/local/mysql/bin/mysqld_safe&

问题解决。

输入您的搜索字词 提交搜索表单

解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题解决了Cant connect to local MySQL server through socket 问题