Error in db connection in php mysql

Question

Please go through the link

http://amymcnamara.com/fortest.php

here this error is giving:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

why this error is giving??

Possible duplicate of http://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mysql-mysql-sock-38. — Bjoern, Jul 03 '12 at 06:37
@RikeshShah That's a domain socket. Nothing to do with firewall. — Maksym Polshcha, Jul 03 '12 at 06:39

score 1 · Answer 1 · answered Jul 03 '12 at 06:36

1

That means that '/var/run/mysqld/mysqld.sock' doesn't exist. The most probably, mysqld is down or utilizes another socket for accepting connections.

answered Jul 03 '12 at 06:36

Maksym Polshcha

18,030
8
52
77

score 0 · Answer 2 · answered Jul 03 '12 at 06:44

0

You need to have mysqld.sock file, which is generated by mysql when it is turned on. Or just create empty file called 'mysqld.sock' in folder - /var/run/mysqld/

answered Jul 03 '12 at 06:44

dpitkevics

1,238
8
12

score 0 · Answer 3 · answered Jul 03 '12 at 07:30

This Error

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /nfs/c09/h01/mnt/130514/domains/amymcnamara.com/html/fortest.php on line 2
Could not connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

usually occur when you give wrong domain name OR username OR Password for database connection so check your connection i think there's error.

Error in db connection in php mysql

3 Answers3