Solution to 2003 server unresponsive issue in phpmyadmin_PHP tutorial

When logging in to phpmyadmin, #2003 - The server is not responding. The first thing that comes to mind is whether your mysql server has stopped. Check it. If the mysql server has stopped serving, restarting can solve the problem.

1. The simplest solution to problems in APMServ5.2.6 is

The APMServ-MySQL5.1 service cannot be started on the local computer, error 1067, process terminated unexpectedly" method is very simple, just enter the "D:\Program Files\APMServ5.2.6\MySQL5.1\bin" folder and find Just execute the mysqld-nt.exe file
. By default, when APMServ is started, MySql5.1 is not started in the service. You need to execute the mysqld-nt.exe file to start the MySql service

2. Let’s check the phpmyadmin configuration file

Method 1: Find

The code is as follows  代码如下 复制代码 $cfg['Servers'][$i]['auth_type'] = ‘config’; 更改为 $cfg['Servers'][$i]['auth_type'] = ‘http’;

Copy code

$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 – Server is not responding" PHPMYADMIN login problem solution Problem description: When logging in to PHPMYADMIN, it prompts #2003 – The server is not responding 1 Other local php+mysql programs run normally;  代码如下 复制代码 $cfg['Servers'][$i]['auth_type']     = ‘config’;    // Authentication method (valid choices: config, http, HTTP, signon or cookie) 验证方式一般填写cookie $cfg['Servers'][$i]['user']          = ‘root’;      // MySQL user $cfg['Servers'][$i]['password']      = ”;          // MySQL password (only needed with ‘config’ auth_type) 将其中的$cfg['Servers'][$i]['password'] 补上相应的正确密码. 3.连接mysql mysql.exe -u root -p -h 127.0.0.1 然后同步密码guoxue_mmkey_com mysql> SET PASSWORD FOR -> ‘ some_user ‘@’ some_host ‘ = OLD_PASSWORD(‘ newpwd ‘); 结合我们的实际情况,在 MySQL Command Line Client 下运行: set password for root@localhost = old_password(’123′);guoxue_mmkey_com guoxue_mmkey_com 2 phpmyadmin used to run normally, but recently it went wrong. Solution: Find the following code segment in the /libraries/config.default.php file: Copy content to clipboard code:

The code is as follows

Copy code

$cfg['Servers'][$i ]['auth_type'] = 'config'; // Authentication method (valid choices: config, http, HTTP, signon or cookie) Authentication method generally fills in cookie

$cfg['Servers'][$i]['user']     = ‘root’;     /  // MySQL user

Note: Check whether the firewall has closed port 3306, or directly close the firewall to test whether you can connect to MYSQL normally, start-run, enter IISRESET to restart IIS, and ensure that mysql starts earlier than IIS http://www.bkjia.com/PHPjc/632933.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632933.htmlTechArticleWhen logging in to phpmyadmin, #2003 - The server does not respond. The first thing that comes to mind is whether your mysql server has stopped checking. For a moment, if the mysql server stops serving, restarting can solve the problem...