mysql 依赖错误_ERROR 2002，mysql数据库报错问题解决方案

]3MtX!@3V }b0

4SV(kN+c0d])e$M0启动mysql 报错：51Testing软件测试网tUP-OU%X@;y51Testing软件测试网/pBn]/RO;CE9?3W

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)Q:]'F*vU051Testing软件测试网"fI|!@oK#N

1、先查看 /etc/rc.d/init.d/mysqld status 看看mysql是否已经启动.| ]Y`Cl

A3D051Testing软件测试网(v k;x9i%[H5d:J

另外看看是不是权限问题.O6vTFc#c*fg051Testing软件测试网

?/cS t"N-~|5@

2、确定你的mysql.sock是不是在那个位置，51Testing软件测试网/G.^7GCE$BqEs51Testing软件测试网fOl

H?ddw;{

mysql -u 你的mysql用户名 -p -S /var/lib/mysql/mysql.sockqK)|M/Fq0

[L@#Y{;Rf rb03、试试：service mysqld start51Testing软件测试网M]TJ_XR51Testing软件测试网y#i"j[\\#g _[

4、如果是权限问题，则先改变权限 #chown -R mysql:mysql /var/lib/mysql51Testing软件测试网%l|(k%lN%xG51Testing软件测试网1tVlNR:N

[root@localhost ~]# /etc/init.d/mysqld startaD"PGga1d*DOA0

l_m+\3_C'pL0启动 MySQL： [ 确定 ]Wrg9HHRv6d|0

+I+o"St:V6{V@(v!|.U0[root@localhost ~]# mysql -u root -p51Testing软件测试网fkKt[!CU

.ZM JA y0ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)51Testing软件测试网fqvI} zQ

;Mt8H.F&o}h:`h(|M;O0原因是，/var/lib/mysql 的访问权限问题。51Testing软件测试网8^e"K'^1e#sy&{51Testing软件测试网'mO V+ZExI!m7xa

shell> chown -R mysql:mysql /var/lib/mysql,o|F6Gy0v0

o8qC\:M7FV]S0接着启动服务器X0N:DdLn2f"G051Testing软件测试网 pl n;g ]n$z

shell> /etc/init.d/mysql start"naB2sW051Testing软件测试网:cU6wS,l\

服务器正常启动后察看 /var/lib/mysql 自动生成mysql.sock文件。51Testing软件测试网c:~K;}~(v/m[

6T\q{1\C{t2p0但是我的问题仍然没有得到解决。51Testing软件测试网'^9K/_ |{

([j^3O)}\\,ru0问题终于解决：Q]

]]"v$M1Ns0

$t+L/A&p:c[}0方法： 修改/etc/my.conf:r;slB7p:q0

!w,sbJmE ^}0[mysqld]51Testing软件测试网e5@J5H4N"z$i4Vw,~51Testing软件测试网+ca/k1ggjA8}

datadir=/usr/local/mysql/data&HNW(c2e4T0

_or}Bno0socket=/var/lib/mysql/mysql.sockv7Af`x051Testing软件测试网9T Gad8JemQ0zD^

[mysql.server]51Testing软件测试网Pj1H8E6m V51Testing软件测试网v/m:ugK

user=mysqldznGtS7g)y0

"^"\-M-p)[0basedir=/usr/local/mysql51Testing软件测试网c"S-f\^C:H_1?4~51Testing软件测试网XS8B

jX0l~#mm

p

If

there is not currently a section called [client], add one at the bottom

of the file and copy the socket= line under the [mysqld] section such

as:1P}^mZdBt;v051Testing软件测试网.Uz$U/Zk'?

[client]pw"\r1{;B_;l051Testing软件测试网5j!t?JJS8yI

socket=/var/lib/mysql/mysql.sock51Testing软件测试网h;t$c

O.p6_

5YZ$fn;|q+[0发现依旧如此，运行/etc/init.d/mysql start报错：Starting MySQLCouldn't find MySQL manager or server51Testing软件测试网hl#k|!Y9oK+KK51Testing软件测试网S/{z:py1bS!IQ

是mysqld服务没启，运行/usr/local/mysql/bin/mysqld_safe &51Testing软件测试网 B@}H&jb

5b i{1Uju0问题解决。51Testing软件测试网?X1DWEx6]

cx"dY&vbd4S0执行 PHP 时出现类似这样的错误信息：'z|u)i-Y0

*D/Z1nL*t0Warning:

MySQL Connection Failed: Can't connect to local MySQL server through

socket '/tmp/mysql.sock' (111) in /home/httpd/html/show.php on line 9h!V!YRf0

-[j.Pl6qVdp0请将 /tmp/mysql.sock link 到 /var/lib/mysql 目录里即可："MDq!^imJK0

DQ/|p

_&x`{&p5k;g0linux# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock51Testing软件测试网K;TaVh#VJA.D