Connecting To A Non Standard MySQL Socket In PHP

11th February 2011 - 4 minutes read time

Connecting to a MySQL database in PHP is usually not a difficult thing to do, in fact it is one of the first things that many tutorials will go though. However, there are certain curcumstances that require more information than the standard host, password and username details. A good example of this is when connecting to a local MySQL server through a different (or at least non standard) socket. The normal place for the MySQL socket to be on a Linux install is /var/run/mysqld/mysqld.sock, but some hosts might change this.

There is a setting in the php.ini file called default_socket, which exists for the pdo_mysql, mysql and mysqli sections and these should be used first if you need to point PHP towards a different socket. There are also system constants called MYSQL_SOCKET and MYSQLI_SOCKET which are created by PHP at compile time with a correctly specified "--with-mysql" setting. Some poorly configured hosts will not compile PHP correctly or not set up these variables and so problems can be experienced when trying to connect to "localhost".

After reading about this for a while I found a lot of confusion on the internet about how all of these settings are created and how they effect PHP when connecting to a MySQL database. MYSQL_SOCKET (and likewise MYSQLI_SOCKET) is used if you specify 'localhost' as the server name. PHP communicates via the socket instead of via TCP/IP in this case. This might only look for socket files in standard locations.

I have read that if the mysql.default_socket setting is specified then that is used instead of the MYSQL_SOCKET setting. My experience is that this isn't the case and that it is the MYSQL_SOCKET setting that takes precedence. If you have any alternative experience of this I would appreciate a comment.

When trying to connect to a localhost that hasn't been configured properly you need to set the socket location when creating a connection to the database. The standard MySQL library and the new MySQLi class work slightly differently here. Assuming that the new socket location is /a/random/directory/mysqld.sock, we can connect to the database using one of the following methods.

$connection = mysql_connect('localhost:3306/a/random/directory/mysqld.sock', 'username', 'password');

$mysqli = new mysqli('localhost', 'username', 'password', "", 3306, '/a/random/directory/mysqld.sock');

This doesn't look that hard, but for people who haven't seen this before (i.e., me) the php.net documentation is a little bit confusing on this issue.

MYSQL_SOCKET
PHP

Add new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
1 + 4 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

Related Content

Recreating Spotify Wrapped In PHP

17th March 2024

I quite like the end of the year report from Spotify that they call "Wrapped". This is a little application in which they tell you what your favorite artist was and what sort of genres you listened to the most during the year.

Read more

Should A Constructor Throw An Exception?

18th February 2024

Let's say you had a class that you wanted to use, but there was some sort of error in creating the object. This might be that the wrong parameters were passed, or the third party service (eg. a database) wasn't available at the time of creation.

Read more

Solving Query Performance Problems With The MySQL Slow Query Log

21st January 2024

MySQL's slow query log is a key component in your MySQL administration setup. Whilst normal logging can help you in terms of tracking down issues with your database system, the slow query log can help you track down issues in your database setup before they become problematic.

Read more

PHP Question: Variable Reference

10th December 2023

Question

What does the following code print out?

function arrayPrint($array)
{
   echo implode(' ', $array);
}

$arrayA = [1, 2, 3];
$arrayB = $arrayA;
$arrayB[1] = 0;
arrayPrint($arrayA);

Read more

Creating An Authentication System With PHP and MariaDB

15th October 2023

Using frameworks to handle the authentication of your PHP application is perfectly fine to do, and normally encouraged. They abstract away all of the complexity of managing users and sessions that need to work in order to allow your application to function.

Read more

Creating Sparklines In PHP

17th September 2023

A sparkline is a very small line graph that is intended to convey some simple information, usually in terms of a numeric value over time. They tend to lack axes or other labels and are added to information readouts in order to expand on numbers in order to give them more context.

Read more