mysqli::real_connect(): (HY000/2002): No such file or directory. code example

Example 1: mysqli_real_connect(): (hy000/2002): no such file or directory

Locate config.sample.inc.php

Change

$cfg['Servers'][$i]['host'] = 'localhost';
into

$cfg['Servers'][$i]['host'] = '127.0.0.1';
Save.

Then rename the file and remove sample from the name.

Example 2: mysqli::real_connect(): (hy000/2002): connection refused

If MySQL Server is up and running - then this looks like some transport (e.g. firewall) problem. First step is to try telnet command below - if it shows an error, then problem is not related to PHP or MySQL :

telnet 66.96.147.118 3306 
(On success it will print mysql version + some random characters)

Tags: