What should I do if a 2003 error occurs in phpmyadmin and the server does not respond?

phpmyadmin has a 2003 error and the server is not responding. Solution: First change [$cfg['Servers'][$i]['auth_type']='config';] to ['http'] ;Then enter your username and password when accessing.

phpmyadmin encountered a 2003 error and the server did not respond. Solution:

Method one: Search

$cfg['Servers'][$i]['auth_type'] = 'config';

Change to

$cfg['Servers'][$i]['auth_type'] = 'http';

You need to enter the user name and password when accessing

Method 2:"#2003 - The server did not respond "PHPMYADMIN login problem solution
Problem description:
Prompt #2003 when logging in to PHPMYADMIN - The server did not respond
1. Other local php mysql programs are running normally;
2. phpmyadmin before It runs normally, but an error occurred recently.

Solution:
Find the following code segment in the /libraries/config.default.php file:
Copy the content to the clipboard code:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie)
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed with 'config' auth_type)

Fill in $cfg['Servers'][$i]['password'] with the corresponding correct password.

Method three: $cfg['Servers'][$i]['port']Configure, then find it, add the port number (default is 3306),

However, it still failed.

So I went to the service to see if MySQL was started, and found that it was not started. It turned out that the problem was here.

Manual startup, the following error occurs:

The system specified path cannot be found

Enter the BIN directory under DOS

C:\Program Files\MySQL\MySQL Server 5.4\bin

Under DOS, enter mysqld-nt -remove to delete the service

and then enter mysqld-nt -install to install the service

The following prompt appears:

The service already exists!
The current server installed: E:\Program Files\MySQL\MySQL Server 5.4\bin\mysqld-nt MySQL

This is caused by the fact that MySQL has been installed before but not uninstalled cleanly

How to clean up mysql?

When you uninstall the old MYSQL database service from your computer, first stop the MYSQL service in the WINDOWS service. Go to the Add and Delete program in the control panel to delete it. However, if you cannot completely delete the MYSQL service, you must clear your MYSQL service in the registry.

There are several places:
1. HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL directory deletion
2. HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL directory Delete
3. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL directory. Delete ControlSet001 and ControlSet002 in the registry. They are not necessarily 001 and 002. They may be ControlSet005 and 006. When deleting, delete them all. You can

check if there is a my.ini file in the C:\WINDOWS directory, delete it

and then reinstall it.

Related tutorial recommendations: phpmyadmin

The above is the detailed content of What should I do if a 2003 error occurs in phpmyadmin and the server does not respond?. For more information, please follow other related articles on the PHP Chinese website!