phpMyAdmin 2003 Server unresponsive Solution

Source: Internet
Author: User
Tags iis php file php and mysql command line phpmyadmin firewall

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

The apmserv-mysql5.1 service cannot be started on the local computer, error 1067, the process is aborted unexpectedly, simply go to the "D:\Program Files\apmserv5.2.6\mysql5.1\bin" folder, Find Mysqld-nt.exe file execution.
By default, when the Apmserv is started, in the service MySql5.1 are not started, need to execute Mysqld-nt.exe file, open MySQL service


2. We'd still check the phpMyAdmin config file to see

Method One: Find

The code is as follows Copy Code
$cfg [' Servers '] [$i] [' auth_type '] = ' config ';
Change to
$cfg [' Servers '] [$i] [' auth_type '] = ' http ';

You need to enter a username and password when accessing

Method Two: "#2003 – The server is not responding" phpMyAdmin landing problem resolution

Problem Description:

Prompt #2003 when landing phpMyAdmin-the server is not responding
1 Local other Php+mysql program running normally;
2 phpMyAdmin has been running normally before, and has recently failed.

Solution:
Locate the following code snippet 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 methods generally fill out cookies
$cfg [' Servers '] [$i] [' User ']    & nbsp;     = ' root ';     //MySQL user
$cfg [' Servers '] [$i] [' Password ']      =;         /MySQL Password (only needed with ' config ' Auth_type)
Add the $cfg[' Servers ' [$i] [' Password '] to the corresponding correct password.
3. Connect MySQL mysql.exe-u root-p-h 127.0.0.1
then sync password guoxue_mmkey_com
mysql> SET PASSWORD for-> ' Some_user ' @ ' Some_host ' = Old_password (' newpwd ');
in conjunction 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 be solved, we recommend that you reconfigure PHP and reinstall MySQL once, you can generally solve


Attention:
Check to see if the firewall shuts down Port 3306, or shut down the firewall test to properly connect to MySQL, start-run, enter iisreset restart IIS, and ensure MySQL starts earlier than IIS

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.