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

$cfg['Servers'][$i]['password'] = ”; // MySQL password (only needed with ‘config’ auth_type) Fill in $cfg['Servers'][$i]['password'] with the corresponding correct password. 3. Connect to mysql mysql.exe -u root -p -h 127.0.0.1 Then synchronize the password guoxue_mmkey_com mysql> SET PASSWORD FOR -> ‘ some_user ‘@’ some_host ‘ = OLD_PASSWORD(‘ newpwd ‘); Combined with our actual situation, run under MySQL Command Line Client: set password for root@localhost = old_password(’123′);guoxue_mmkey_com guoxue_mmkey_com If none of the above methods can solve the problem, it is recommended to reconfigure PHP and reinstall mysql, which usually solves the problem

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