Solution to the 2003 error when phpmyadmin logs in: 1. Find [$cfg['Servers'][$i]['auth_type'] = 'config'] and change it to [**= 'http'] ;2. Fill $cfg['Servers'] with the correct code.
【Related tutorial recommendations: phpmyadmin】
Solution to the 2003 error when phpmyadmin logs in:
Method 1: Find$cfg['Servers'][$i]['auth_type'] = 'config';
Change to$cfg['Servers'][$i]['auth_type'] = 'http';
You need to enter your username and password when accessing
Method 2: "#2003 - The server is not responding"Solution to the PHPMYADMIN login problem
Problem description:
Prompt when logging in to PHPMYADMIN#2003 -The server is not responding
1 Other local php mysql programs are running normally;
2 phpmyadmin used to run normally, but an error occurred recently.
Solution:
Find /libraries/config. The following code segment in the default.php file:
Copy 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)
Replace $cfg['Servers'][$i]['password' ]
Fill in the corresponding correct password.
Method three: $cfg['Servers'][$i]['port']
Configuration, Then I found it and added the port number (the 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
Enter under DOS mysqld- nt -remove
Delete the service
Then enter mysqld-nt -install
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 because I have installed MySQL before and failed to uninstall it.
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 deletion
3, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL directory deletion ControlSet001, ControlSet002 in the registry, not necessarily 001 and 002, may be ControlSet005, 006 When deleting, just delete them all
Check if there is a my.ini file in the C:\WINDOWS directory, delete it
Just reinstall it again.
Related learning recommendations: Programming video
The above is the detailed content of What should I do if a 2003 error occurs when phpmyadmin is logged in?. For more information, please follow other related articles on the PHP Chinese website!