Warning: mysql_connect(): [2002] No such file or d

Question

I'm trying to connect to my MySQL DB with the Terminal on my Apple (With PHP).

Yesterday it worked fine, and now I suddenly get the error in the title.

The script works when I use my browser to run it (I have XAMPP installed), but Terminal refuses to connect to the DB.

Here is the file that I include to connect (the script works when I don't include this, but then it doesn't connect to the DB):

<?php
    mysql_connect("localhost", "root", "") or die(mysql_error());
    mysql_select_db("FNB1C_data") or die(mysql_error());
?>

That should work, since it works with my browser.

The command I use at the Terminal is php scriptname.php.

Answer 1

The reason is that php cannot find the correct path of mysql.sock.

Please make sure that your mysql is running first.

Then, please confirm that which path is the mysql.sock located, for example /tmp/mysql.sock

then add this path string to php.ini:

• mysql.default_socket = /tmp/mysql.sock
• mysqli.default_socket = /tmp/mysql.sock
• pdo_mysql.default_socket = /tmp/mysql.sock

Finally, restart Apache.

Answer 2

I also had this error, but could only fix it through the suggestion here.

To summarize, use:

127.0.0.1

Instead of:

localhost

The reason is that "localhost" is a special name for the MySQL driver making it use the UNIX socket to connect to MySQL instead of the a TCP socket.

Answer 3

Another solution is to fix the socket location in the php.ini configuration file like this:

pdo_mysql.default_socket=/tmp/mysql.sock

Of course, the symlink works too, so its a matter of preference which one you change.

Answer 4

MySQL socket is located, in general, in /tmp/mysql.sock or /var/mysql/mysql.sock, but probably PHP looks in the wrong place.

1. Check where is your socket with:

    sudo /usr/libexec/locate.updatedb
   

2. When the updatedb is terminated:

    locate mysql.sock
   

3. Then locate your php.ini:

    php -i | grep php.ini
   

   this will output something like:

    Configuration File (php.ini) Path => /opt/local/etc/php54
    Loaded Configuration File => /opt/local/etc/php54/php.ini
   

4. Edit your php.ini

    sudo vim /opt/local/etc/php54/php.ini
   

5. Change the lines:

    pdo_mysql.default_socket=/tmp/mysql.sock
    mysql.default_socket=/tmp/mysql.sock
    mysqli.default_socket = /tmp/mysql.sock
   

   where /tmp/mysql.sock is the path to your socket.

6. Save your modifications and exit ESC + SHIFT: x

7. Restart Apache

    sudo apachectl stop
    sudo apachectl start
   

Answer 5

Mac OS X EL Capitan + MAMP Pro Do this

cd /var
sudo mkdir mysql
sudo chmod 755 mysql
cd mysql
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock mysql.sock

Then do this

cd /tmp
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock mysql.sock

Hope this saves you some time.

Answer 6

When you install php53-mysql using port it returns the following message which is the solution to this problem:

To use mysqlnd with a local MySQL server, edit /opt/local/etc/php53/php.ini
and set mysql.default_socket, mysqli.default_socket and
pdo_mysql.default_socket to the path to your MySQL server's socket file.

For mysql5, use /opt/local/var/run/mysql5/mysqld.sock
For mysql51, use /opt/local/var/run/mysql51/mysqld.sock
For mysql55, use /opt/local/var/run/mysql55/mysqld.sock
For mariadb, use /opt/local/var/run/mariadb/mysqld.sock
For percona, use /opt/local/var/run/percona/mysqld.sock