php warning mysql_connect

Question

I am having problem while connecting php with mysql. Mysql server and client is running fine.And mysql socket file is in

/var/mysql/mysql.sock

But while connecting like :

$con = mysql_connect("localhost","root","pass");

It says

Socket operation on non-socket (trying to connect via unix:///var/mysql/mysql.sock)

Any clue?

Answer to your issue: http://stackoverflow.com/a/9477985/1514026 — Dzhuneyt, Aug 17 '12 at 14:32
Don't use mysql_* functions at all, instead use mysqli or PDO, as written in the [manual](http://php.net/manual/en/function.mysql-connect.php) — DannyCruzeira, Aug 17 '12 at 14:36
possible duplicate of [MySQL is running without a socket file](http://stackoverflow.com/questions/9477552/mysql-is-running-without-a-socket-file) — Jürgen Thelen, Aug 17 '12 at 15:10

score 1 · Accepted Answer · answered Aug 17 '12 at 14:30

1

use

$con = mysql_connect("127.0.0.1","","");

answered Aug 17 '12 at 14:30

mushfiq

Pointless if the server isn't configured to allow TCP connections, which most aren't, by default. – Marc B Aug 17 '12 at 14:54

score 0 · Answer 2 · answered Aug 17 '12 at 14:51

0

It sounds like your actual MySQL Socket File is in a different location than where PHP is expecting it to be.

Do a phpinfo(); and see what the location of the socket file should be, per PHP.

You can then symlink it from where it is currently located.

answered Aug 17 '12 at 14:51

Mike Mackintosh

2 Answers2