#2002 - No such file or directory — The server is not responding (or the local server's socket is not correctly configured).

Question

When I try to login my PHPMyAdmin, I get the following error messages:

#2002 - No such file or directory &mdash; The server is not responding (or the local server's socket is not correctly configured).

mysqli_real_connect(): (HY000/2002): No such file or directory

Connection for controluser as defined in your configuration failed.

Error screenshot: https://www.screencast.com/t/TciiR9NIBi

but after rebooting my droplet, I am able to use my WordPress and PHPMyAdmin normally without any errors!

It’s really frustrating to get that error randomly!
Please help me.

Answer 1

bobbyiliev August 27, 2019

Hello,

I would recommend changeinglocalhost to 127.0.0.1 in your config.inc.php PHPmyAdmin file.

It should look something like this after the change:

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

That way when using 127.0.0.1 PHPmyAdmin would make a TCP connection which should work.

Let me know how it goes.
Regards,
Bobby

Reply Report

bepari662 August 28, 2019

Thanks, It is working
Reply Report
- bobbyiliev August 28, 2019
  
  Hello,
  
  No problem at all! I’m happy to hear that it is working as expected!
  
  Regards,
  Bobby
  
  Reply Report
ShahinKazi January 21, 2021

[deleted]
Reply Report
ShahinKazi January 21, 2021
I do see these lines

if (check_file_access('/etc/phpmyadmin/config-db.php')) { require('/etc/phpmyadmin/config-db.php'); } /* Configure according to dbconfig-common if enabled */ if (!empty($dbname)) { /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ if (empty($dbserver)) $dbserver = 'localhost'; $cfg['Servers'][$i]['host'] = $dbserver; if (!empty($dbport) || $dbserver != 'localhost') { $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['port'] = $dbport; ``` }
Reply Report
- bobbyiliev January 21, 2021
  
  Hi there,
  
  As suggested by @bepari662, if you are on a low memory Droplet, you could add a SWAP file for some extra buffer:
  
  https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04
  
  Regards,
  Bobby
  
  How To Add Swap Space on Ubuntu 18.04
  by Brian Boucheron
  One of the easiest way of guarding against out-of-memory errors in applications is to add some swap space to your server. In this guide, we will cover how to add a swap file to an Ubuntu 18.04 server.
  
  Reply Report

Answer 2

bepari662 August 28, 2019

Thanks, It is working
Reply Report
- bobbyiliev August 28, 2019
  
  Hello,
  
  No problem at all! I’m happy to hear that it is working as expected!
  
  Regards,
  Bobby
  
  Reply Report
ShahinKazi January 21, 2021

[deleted]
Reply Report
ShahinKazi January 21, 2021
I do see these lines

if (check_file_access('/etc/phpmyadmin/config-db.php')) { require('/etc/phpmyadmin/config-db.php'); } /* Configure according to dbconfig-common if enabled */ if (!empty($dbname)) { /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ if (empty($dbserver)) $dbserver = 'localhost'; $cfg['Servers'][$i]['host'] = $dbserver; if (!empty($dbport) || $dbserver != 'localhost') { $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['port'] = $dbport; ``` }
Reply Report
- bobbyiliev January 21, 2021
  
  Hi there,
  
  As suggested by @bepari662, if you are on a low memory Droplet, you could add a SWAP file for some extra buffer:
  
  https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04
  
  Regards,
  Bobby
  
  How To Add Swap Space on Ubuntu 18.04
  by Brian Boucheron
  One of the easiest way of guarding against out-of-memory errors in applications is to add some swap space to your server. In this guide, we will cover how to add a swap file to an Ubuntu 18.04 server.
  
  Reply Report

Answer 3

komi November 4, 2019

I’m having the same error and it pops randomly also. The above fix it didn’t worked for me. That line is commented and I have this instead:

/* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    if (empty($dbserver)) $dbserver = '127.0.0.1';
    $cfg['Servers'][$i]['host'] = $dbserver;

    if (!empty($dbport) || $dbserver != '127.0.0.1') {
        $cfg['Servers'][$i]['connect_type'] = 'tcp';
        $cfg['Servers'][$i]['port'] = $dbport;
    }

A you can see i have replaced the localhost with the IP suggested but still that error pops up from time to time. Any suggestion?

Reply Report

bepari662 November 5, 2019

Make a SWAP if you are using a low memory droplet.

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04

How To Add Swap Space on Ubuntu 18.04
by Brian Boucheron
One of the easiest way of guarding against out-of-memory errors in applications is to add some swap space to your server. In this guide, we will cover how to add a swap file to an Ubuntu 18.04 server.
Reply Report

Answer 4

bepari662 November 5, 2019

Make a SWAP if you are using a low memory droplet.

https://www.digitalocean.com/community/tutorials/how-to-add-swap-space-on-ubuntu-18-04

How To Add Swap Space on Ubuntu 18.04
by Brian Boucheron
One of the easiest way of guarding against out-of-memory errors in applications is to add some swap space to your server. In this guide, we will cover how to add a swap file to an Ubuntu 18.04 server.
Reply Report

Related

Question

#2002 - No such file or directory — The server is not responding (or the local server's socket is not correctly configured).

Related

Leave a comment

Looking for something else?

Sign up for our newsletter

Related

Question

#2002 - No such file or directory &mdash; The server is not responding (or the local server's socket is not correctly configured).

Related

Leave a comment

Related

question

Configure phpmyadmin to communicate to remote mysql server on private network

question

Error On phpMyAdmin

question

Setting my project public folder as document root

question

Can't install phpMyAdmin

Looking for something else?

#2002 - No such file or directory — The server is not responding (or the local server's socket is not correctly configured).