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
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:
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
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