phpmyadmin server 2003 no response solution summary

  • 2020-05-13 03:36:12
  • OfStack

1. The simplest solution to the problem in APMServ5.2.6 is

Unable to start the APMServ-MySQL5.1 service on the local computer, error 1067, process aborted "is as simple as going to the" D: \ Program Files \ APMServ5.2.6 \ MySQL5.1 \ bin "folder and finding the mysqld-nt.exe file to execute.
By default, when APMServ is started, MySql5.1 is not started in the service. mysqld-nt.exe file needs to be executed to start MySql service

2. Let's check the phpmyadmin configuration file

Method 1: search
 
$cfg['Servers'][$i]['auth_type'] = 'config'; 
 Change to  
$cfg['Servers'][$i]['auth_type'] = 'http'; 

You need to enter a username and password to access it

Method 2: "no response from the server" PHPMYADMIN login problem was solved

Problem description:

When logging in PHPMYADMIN, the #2003 copyright server is not responding
1 local other php+mysql programs are running normally;
2 phpmyadmin worked normally before, but recently it failed.

Solutions:
Find/libraries config. default. php files in the following code snippet:
 
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie)  Verify the way 1 A complete cookie 
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user 
$cfg['Servers'][$i]['password'] =  " ; // MySQL password (only needed with 'config' auth_type) 
 Will be one of the $cfg['Servers'][$i]['password']  Fill in the correct password . 
3. The connection mysql mysql.exe -u root -p -h 127.0.0.1 
 And then synchronize the password guoxue_mmkey_com 
mysql> SET PASSWORD FOR -> ' some_user '@' some_host ' = OLD_PASSWORD(' newpwd '); 
 Combined with our actual situation , in  MySQL Command Line Client  Run under : 
set password for root@localhost = old_password('123 ' );guoxue_mmkey_com 
guoxue_mmkey_com 

If none of the above methods can be solved, it is recommended to reconfigure PHP and reinstall mysql once, which can generally be solved

Note:
Check whether the firewall has closed port 3306, or directly close the firewall to test whether it can connect to MYSQL normally, start-run, enter IISRESET and restart IIS to ensure that mysql starts earlier than IIS

Related articles: