mysql\uff0cmysqldump\uff0cphp\u8fde\u63a5mysql\u670d\u52a1\u5e38\u4f1a\u63d0\u793a\u4e0b\u9762\u9519\u8bef\uff1a<\/p>\n
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘\/var\/lib\/mysql\/mysql.sock’ (2)<\/p>\n
\u4ea7\u751f\u6b64\u95ee\u9898\u7684\u539f\u56e0\u4e00\u822c\u6709\u4e24\u4e2a\uff1a<\/p>\n
1\u3001mysql\u670d\u52a1\u672a\u6b63\u5e38\u8fd0\u884c\uff1a<\/p>\n
\u7531\u4e8emysql\u7684socket\u6587\u4ef6\u662f\u7531mysqld\u670d\u52a1\u542f\u52a8\u65f6\u521b\u5efa\u7684\uff0c\u5982\u679cmysqld\u670d\u52a1\u672a\u6b63\u5e38\u542f\u52a8\uff0csocket\u6587\u4ef6\u81ea\u7136\u4e5f\u4e0d\u4f1a\u88ab\u521b\u5efa\uff0c\u5f53\u7136\u4f1a\u627e\u4e0d\u5230socket\u6587\u4ef6\u4e86\u3002\u5bf9\u4e8e\u5224\u65admysql\u670d\u52a1\u662f\u5426\u542f\u52a8\uff0c\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528\u4e0b\u9762\u547d\u4ee4\uff1a<\/p>\n
# 1\u3001 \u7aef\u53e3\u662f\u5426\u6253\u5f00<\/p>\n
[root@aiezu.com ~]# lsof -i:3306<\/p>\n
COMMAND\u00a0 PID\u00a0 USER\u00a0 FD\u00a0 TYPE DEVICE SIZE\/OFF NODE NAME<\/p>\n
mysqld\u00a0 12207 mysql\u00a0 14u\u00a0 IPv4\u00a0 52350\u00a0 \u00a0 \u00a0 0t0\u00a0 TCP *:mysql (LISTEN)<\/p>\n
# 2\u3001mysqld\u670d\u52a1\u662f\u5426\u6b63\u5728\u8fd0\u884c<\/p>\n
[root@aiezu.com ~]# service mysqld status<\/p>\n
mysqld (pid\u00a0 4717) is running…<\/p>\n
2\u3001socket\u6587\u4ef6\u8def\u5f84\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u8bbe\u7f6e\u4e0d\u5b8c\u6574\uff1a<\/p>\n
\u8fd9\u4e00\u822c\u662f\u7531\u4e8e\u6211\u4eec\u4fee\u6539\u4e86mysql\u914d\u7f6e\u201c\/etc\/my.cnf\u201d\u5f15\u8d77\u7684\u3002\u6bd4\u5982\u6211\u4eec\u4fee\u6539\u4e86\u914d\u7f6e\u6587\u4ef6\u4e2d\u201c[mysql]\u201d\u9009\u9879\u4e0b\u7684\u201csocket\u201d\u53c2\u6570\uff0c\u800c\u672a\u6307\u5b9a\u201c[client]\u201d\u3001\u201c[mysql]\u201d\u9009\u9879\u7684\u201csocket\u201d\u53c2\u6570\uff0c\u5bfc\u81f4mysql\u4f7f\u7528\u9ed8\u8ba4\u7684socket\u6587\u4ef6\u4f4d\u7f6e\u53bb\u5bfb\u627esocket\u6587\u4ef6\uff0c\u4ece\u800c\u5bfc\u81f4\u672a\u627e\u5230socket\u6587\u4ef6\u800c\u5f15\u53d1\u6b64\u9519\u8bef\u3002<\/p>\n
\u4e0b\u9762\u662f\u89e3\u51b3\u65b9\u6cd5<\/strong><\/p>\n 1\u3001mysql\u670d\u52a1\u672a\u6b63\u5e38\u8fd0\u884c\uff1a<\/p>\n \u5982\u679c\u662f\u670d\u52a1\u672a\u542f\u52a8\uff0c\u6211\u4eec\u8fd0\u884c\u201cservice mysqld start\u201d\u542f\u52a8\u670d\u52a1\u5373\u53ef\u3002\u5982\u679c\u670d\u52a1\u542f\u52a8\u4e0d\u4e86\uff0c\u5c31\u53bb\u67e5\u770bmysql\u670d\u52a1\u65e5\u5fd7\uff0c\u5bfb\u627e\u539f\u56e0\u5e76\u89e3\u51b3\u518d\u542f\u52a8<\/p>\n [root@aiezu.com ~]# service mysqld start<\/p>\n Starting mysqld:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [\u00a0 OK\u00a0 ]<\/p>\n [root@aiezu.com ~]# lsof -i:3306<\/p>\n COMMAND\u00a0 PID\u00a0 USER\u00a0 FD\u00a0 TYPE\u00a0 \u00a0 DEVICE SIZE\/OFF NODE NAME<\/p>\n mysqld\u00a0 14109 mysql\u00a0 10u\u00a0 IPv4 247183583\u00a0 \u00a0 \u00a0 0t0\u00a0 TCP *:mysql (LISTEN)<\/p>\n [root@aiezu.com ~]# service mysqld status<\/p>\n mysqld (pid\u00a0 14109) is running…<\/p>\n 2\u3001\u5b8c\u5584mysql\u914d\u7f6e\u6587\u4ef6\uff1a<\/p>\n \u5982\u679c\u786e\u8ba4mysql\u670d\u52a1\u6b63\u5e38\u8fd0\u884c\uff0c\u8fd8\u63d0\u793a\u6587\u7ae0\u6807\u9898\u7684\u6b64\u9519\u8bef\uff0c\u90a3\u5c31\u662f\u201c\/etc\/my.cnf\u201d\u914d\u7f6e\u6587\u4ef6\u7684\u95ee\u9898\u4e86\u3002\u89e3\u51b3\u529e\u6cd5\u662f\u4fee\u6539\u201c\/etc\/my.cnf\u201d\u914d\u7f6e\u6587\u4ef6\uff0c\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6dfb\u52a0\u201c[client]\u201d\u9009\u9879\u548c\u201c[mysql]\u201d\u9009\u9879\uff0c\u5e76\u4f7f\u7528\u8fd9\u4e24\u4e2a\u9009\u9879\u4e0b\u7684\u201csocket\u201d\u53c2\u6570\u503c\uff0c\u4e0e\u201c[mysqld]\u201d\u9009\u9879\u4e0b\u7684\u201csocket\u201d\u53c2\u6570\u503c\uff0c\u6307\u5411\u7684socket\u6587\u4ef6\u8def\u5f84\u5b8c\u5168\u4e00\u81f4\u3002\u5982\u4e0b\uff1a<\/p>\n [mysqld]<\/p>\n datadir=\/storage\/db\/mysql<\/p>\n socket=\/storage\/db\/mysql\/mysql.sock<\/p>\n …\u7701\u7565n\u884c\uff08\u7231E\u65cf\uff09…<\/p>\n [client]<\/p>\n default-character-set=utf8<\/p>\n socket=\/storage\/db\/mysql\/mysql.sock<\/p>\n [mysql]<\/p>\n default-character-set=utf8<\/p>\n socket=\/storage\/db\/mysql\/mysql.sock<\/p>\n \u5176\u4e2dsocket\u7b49\u4e8e\u7684\u8def\u5f84\u5c31\u662fsocket\u6587\u4ef6\u7684\u4f4d\u7f6e\uff0c\u6211\u4eec\u53ea\u8981\u4fee\u6539my.cnf\u6587\u4ef6,\u544a\u8bc9mysql\uff0cmysqldump\uff0cmysqladmin\u7b49\u547d\u4ee4\uff0cmysql\u670d\u52a1\u7684socket\u6587\u4ef6\u4f4d\u7f6e\u5728\u54ea\u91cc\uff0c\u7136\u540e\u91cd\u542fmysqld\u670d\u52a1\u5373\u53ef\u3002<\/p>\n 3\u3001php\u8fde\u63a5mysql\u670d\u52a1\u63d0\u793a”Can’t connect to local MySQL server through socket…”\u7684\u89e3\u51b3\u65b9\u6cd5<\/p>\n \u6709\u65f6\u5019mysql\u670d\u52a1\u6b63\u5e38\u8fd0\u884c,\u7528\u6237\u540d\u5bc6\u7801\u4e5f\u5b8c\u5168\u6b63\u786e\uff0c\u4f7f\u7528php\u7684mysql_connect\u51fd\u6570\u5374\u8fde\u63a5\u4e0d\u4e86mysql\uff0c\u8c03\u7528php\u7684mysql_error()\u51fd\u6570\u63d0\u793a\u201cCan’t connect to local MySQL server through socket ‘\/var\/lib\/mysql\/mysql.sock’\u201d\uff0c\u8fd9\u662f\u6211\u4eec\u9700\u8981\u4fee\u6539\/etc\/php.ini\u6587\u4ef6\u3002<\/p>\n \u5728\/etc\/php.ini\u6587\u4ef6\u4e2d”[MySQL]”\u9879\u4e0b\u627e\u5230”mysql.default_socket”\uff0c\u5e76\u8bbe\u7f6e\u5176\u503c\u6307\u5411\u6b63\u786e\u7684mysql\u670d\u52a1socket\u6587\u4ef6\u5373\u53ef\uff0c\u5982:<\/p>\n [MySQL]<\/p>\n …\u7701\u7565n\u884c…<\/p>\n mysql.default_socket = “\/storage\/db\/mysql\/mysql.sock”<\/p>\n 4\u3001python\u8fde\u63a5mysql\u63d0\u793a”Can’t connect to local MySQL server through socket…”\u7684\u89e3\u51b3\u65b9\u6cd5:<\/p>\n \u5728\u8fde\u63a5mysql\u6570\u636e\u5e93\u51fd\u6570\u4e2d\u6307\u5b9asocket\u6587\u4ef6\uff0c\u5982\u4e0b\uff1a<\/p>\n #!\/usr\/bin\/python<\/p>\n from MySQLdb import connect<\/p>\n conn = connect(db=”pzy”, user=”root”, host=”localhost”, unix_socket=”\/storage\/db\/mysql\/mysql.sock”)<\/p>\n cur = conn.cursor()<\/p>\n count=cur.execute(“show databases”)<\/p>\n print ‘there has %s dbs’ % count<\/p>\n conn.commit()<\/p>\n conn.close()<\/p>\n 5. php pdo\u8fde\u63a5mysql\u63d0\u793a”Can’t connect to local MySQL server through socket…”\u7684\u89e3\u51b3\u65b9\u6cd5:<\/p>\n \u540c\u6837\u5728\u8fde\u63a5\u5b57\u7b26\u4e32\u6dfb\u52a0mysql socket\u6587\u4ef6\u7684\u4f4d\u7f6e\u5373\u53ef\uff0c\u5982\u4e0b:<\/p>\n <?php<\/p>\n $dsn = “mysql:host=localhost;dbname=pzy;unix_socket=\/storage\/db\/mysql\/mysql.sock”;<\/p>\n $db = new PDO($dsn, ‘root’, ”);<\/p>\n $rs = $db->query(“SELECT * FROM qrtest”);<\/p>\n while($row = $rs->fetch()){<\/p>\n print_r($row);<\/p>\n }<\/p>\n ?><\/p>\n \u8981\u8865\u5145\u7684\u5730\u65b9\u662f\u8bf4\u8fd9\u4e2amysql.sock\u6587\u4ef6\u7684\u4f4d\u7f6e\uff0c\u6211\u7684\u6587\u4ef6\u662f\u5728\/tmp\/mysql.sock\u00a0 \u4f46\u662f\u6253\u5f00\u91cc\u9762\u662f\u7a7a\u7684\uff0c\u6240\u4ee5\u5f53\u65f6\u6709\u4e00\u4e9b\u7591\u60d1\u00a0 \u7ecf\u8fc7\u5b9e\u9a8c \u8bc1\u660e\u786e\u5b9e\u5c31\u662f\u8fd9\u4e2a\/tmp\/mysql.sock\u00a0 \u6211\u7684\u95ee\u9898\u4e3b\u8981\u662fphp\u8fde\u63a5\u4e0d\u4e0a\uff0cmysql\u5ba2\u6237\u7aef\u662f\u53ef\u4ee5\u7684\uff0c\u7136\u540e\u6539\u4e86 php.ini\u00a0 \u91cd\u542fphp-fpm\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"