Can’t access your MySQL server via phpMyAdmin due to error 2002?

A MySQL service restart or configuration correction can let you access the MySQL server.

At Bobcares, we often get requests to fix phpMyAdmin errors, as a part of our Server Management Services.

Today, let’s see how our Support Engineers fix this error.

What is phpMyAdmin error 2002?

phpMyAdmin is a tool to manage MySQL database via a front panel. This tool makes database management easier with the user interface.

But what if you can’t even access it? The typical error message while a user tries to access it appears as:

phpMyAdmin error 2002 is a common error when a new user is accessing it. Because of the newly setup configuration is not proper. It needs some corrections. Otherwise, the MySQL server is not working,

Our Experts in Server Administration always fix this error for our customers. Let’s see how we do it.

How we fix phpMyAdmin error 2002?

Customers often approach us with the error message ‘2002 Cannot log in to the MySQL server‘. Let us discuss how our Support Engineers resolve the error for our customers.

1. If MySQL server is down

In this case, our Support Team first checks if the MySQL server is functioning properly. If not we restart the service.

For a CentOS server, we use the command,

/etc/init.d/mysql restart

In most cases this fixes the error.

2. Improper configuration

If the server is up, next our Support Engineers check the configuration file.

By default, phpmyadmin/config.sample.inc.php is the configuration file. We make a copy of this file in the name phpmyadmin/config.inc.php.

This file holds the configuration needed for phpMyAdmin to function.

We check for entries that mostly lead to error. That is,

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

This indicates the server host. We change this to localhost IP (127.0.0.1).

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

Now we try to connect to phpMyAdmin. If the error still persist we make changes to the other parameters as well.

Another parameter is the connection type, which we set it accordingly. Here it is set to tcp.

$cfg['Servers'][$i]['connect_type'] = 'tcp';

In case of socket connection the required changes are:

$cfg['Servers'][$i]['socket'] = 'location of socket file';

$cfg['Servers'][$i]['connect_type'] = 'socket';

Hence we ensure to fix the error.

[Need assistance in fixing phpMyAdmin errors? – We’ll help you.]

Conclusion

In short, phpMyAdmin error 2002 occurs when the user tries to access it. This error indicates that either the MySQL server is down or the phpMyAdmin has a bad configuration. Today, we saw how our Support Engineers fix this error.