Server 2008 running MySQL I get #2003 - The server is not responding

tbonehwd
tbonehwd used Ask the Experts™
on
I am attempting to do the following that I found on (http://www.trainsignaltraining.com/install-phpmyadmin-on-iis7-and-server-2008/)

Install MySQL on IIS7 Server 2008
IIS 7: Install FastCGI & PHP on Server 2008
Install PHPMyAdmin on IIS7 and Server 2008

I am running Windows Server 2008, IIS7, PHP 5.2.10 (which as far as I can tell is correctly configured), MySQL Essentials 5.0.83, and phpMyAdmin 2.11.9.5. All is great until I try to log into phpMyAdmin. In config.inc.php I have the following lines which the password here matches what I used when I installed MySQL

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = 'testpass';

 I am stuck on the PHPMyAdmin with error: #2003 - The server is not responding

Any help would be much appreciated...

Thank you...
phpmyadmin.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Are you sure the mysql service is running? can you connect to mysql from a prompt? Also, mysql runs default on 3306, make sure you are not blocking that port.
Also:

Here is a copy of my config.inc.php:
if you set your auth_type to http then you don;t have to specif username/password in config file, you will get a pop-up prompt - as can be seen from my example where contol user /pass is commented out completely.

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'your_host_ip_or_localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/*
 * End of servers configuration
 */

Author

Commented:
First off I have to say I have never done this before and I am a bit clueless but with that said I am pretty sure that MySQL is running and we are not blocking the port:

mysql> \s
--------------
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe Ver 14.12 Distrib 5.0.83,
for Win32 (ia32)

Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.0.83-community-nt MySQL Community Edition (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
TCP port: 3307
Uptime: 1 hour 31 min 42 sec

Threads: 1 Questions: 5 Slow queries: 0 Opens: 12 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.001
--------------

mysql>

When I changed the auth type to http I get another screen:
Welcome to phpMyAdmin 2.11.9.5

Probably reason of this is that you did not create configuration file. You might want to use setup script to create one. Error
MySQL said: #2003 - The server is not responding
phpMyAdmin was unable to read your configuration file!
This might happen if PHP finds a parse error in it or PHP cannot find the file.
Please call the configuration file directly using the link below and read the PHP error message(s) that you receive. In most cases a quote or a semicolon is missing somewhere.
If you receive a blank page, everything is fine.

./config.inc.php Open new phpMyAdmin window
Any thoughts?
11/26 Forrester Webinar: Savings for Enterprise

How can your organization benefit from savings just by replacing your legacy backup solutions with Acronis' #CyberProtection? Join Forrester's Joe Branca and Ryan Davis from Acronis live as they explain how you can too.

Author

Commented:
I finallly got... Although you did help me along
What was the solution that you have found?

Author

Commented:
I am sorry... I thought I posted the solution. The problem I had was the name of localhost on the test machine I first installed everything on when I was in phpMyAdmin it stated the server was localhost:3306 when I used localhost:3306 in the wp-config.php it worked.

/** MySQL hostname */
define('DB_HOST', 'localhost:3306');

After I got it working I installed everything again on the production server and this time it was just localhost I am not sure what caused the problem in the first place but I was able to move on...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial