不能通过mysql.sock连接MySQL问题的解决办法

这个问题主要提示是，不能通过'/tmp/mysql.sock'连到服务器，而php标准配置正是用过'/tmp/mysql.sock'，但是一些mysql安装方法将mysql.sock放在/var/lib/mysql.sock或者其他的什么地方，你可以通过修改/etc/my.cnf文件来修正它，打开文件，可以看到如下的东东：

[mysqld]

socket=/var/lib/mysql.sock

改一下就好了，但也会引起其他的问题，如mysql程序连不上了，再加一点：

[mysql]

socket=/tmp/mysql.sock

或者还可以通过修改php.ini中的配置来使php用其他的mysql.sock来连，这个大家自己去找找

或者用这样的方法:

ln-s/var/lib/mysql/mysql.sock/tmp/mysql.sock

还有:

phpmyadmin的说明书有说

Theerrormessage"Warning:MySQLConnectionFailed:Can'tconnecttolocalMySQLserverthroughsocket'/tmp/mysql.sock'(111)..."isdisplayed.WhatcanIdo?

ForRedHatusers,HaraldLegnersuggeststhisonthemailinglist:

OnmyRedHat-Boxthesocketofmysqlis/var/lib/mysql/mysql.sock.Inyourphp.iniyouwillfindaline

mysql.default_socket=/tmp/mysql.sock

changeitto

mysql.default_socket=/var/lib/mysql/mysql.sock

Thenrestartapacheanditwillwork.

HereisafixsuggestedbyBradUmmerinthephpwizardforum:

First,youneedtodeterminewhatsocketisbeingusedbyMySQL.

Todothis,telnettoyourserverandgototheMySQLbindirectory.Inthisdirectorythereshouldbeafilenamedmysqladmin.Type./mysqladminvariables,andthisshouldgiveyouabunchofinfoaboutyourMySQLserver,includingthesocket(/tmp/mysql.sock,forexample).

Then,youneedtotellPHPtousethissocket.

AssumingyouareusingPHP3.0.10orbetter,youcanspecifythesockettousewhenyouopentheconnection.TodothisinphpMyAdmin,youneedtocompletethesocketinformationintheconfig.inc.php3.

Forexample:$cfg['Servers'][$i]['socket']='/tmp/mysql.sock';