#2002 - The server is not responding (XP SP2) 1.7.7 [SOLVED]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

#2002 - The server is not responding (XP SP2) 1.7.7 [SOLVED]

Postby AshishNehete » 20. October 2011 06:11

Hi,
I am a newbie to Xampp but i have used it earlier so i know some of the basics.

I recently formatted my laptop installing Windows 7 in it
i installed Xampp 1.7.7 on it every thing runs fine as it was suppose to but i am not able to get the phpMyAdmin to work.
It displays the following error:-

MySQL said: Documentation
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Connection for controluser as defined in your configuration failed.


I searched for solution at many places but couldn't get it working

Please help this issue is driving me nuts!! :x
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 06:19

Try this possible solution, one of many:
Open the C:\xampp\mysql\bin\my.ini (default installation location, change to suit) in your text editor and uncomment this line (remove this character # from the beginning of the line) so it looks like this
Code: Select all
bind-address = "127.0.0.1"
Save the file and restart Apache and MySQL.

If you get phpMyAdmin to open then you will need to change the default language from German to a language of your choice.

Please let me know back if that helps.

Thanks and good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 09:06

hi sharley

There is no line like that in the C:\xampp\phpmyadmin\config.inc.php

it looks like this
<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* 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';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

/*
* End of servers configuration
*/

?>
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 09:09

You are right and I gave you the wrong file - sorry.

The file is C:\xampp\mysql\bin\my.ini

Thanks for pointing that out :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 09:21

Still the same sharley!
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 09:25

AshishNehete wrote:
<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* 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';
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

/*
* End of servers configuration
*/

?>
Change the red line above so it looks identicle, save the file and restart Apache and MySQL.

Better luck this time. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 09:39

i got the phpMyAdmin page
it asks for username and password

but i havent ever specifed any
so i enter
Username: root
Password: "blank"

this is being shown

Image
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 09:39

http://imageshack.us/photo/my-images/831/capturedzy.jpg/
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 09:44

Username is root not roo: and no password.

Check the windows hosts file has this line as the first uncommented line:
Code: Select all
127.0.0.1 localhost

C:\Windows\system32\drivers\etc\HOSTS - drag it into your text editor or right click and open your text editor as administrator.

See if there is anything in this topic that helps:
viewtopic.php?f=16&t=48481
Especially this post:
viewtopic.php?p=186375#p186375
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 09:52

#2002 Cannot log in to the MySQL server
Language

Log inphpMyAdmin documentation
Username: root
Password:
Connection for controluser as defined in your configuration failed.


I am getting this!
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 09:56

See my last post as I added more info. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 10:35

Thank you very much sharley! :D
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 10:37

Was it the hosts file fix?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #2002 - The server is not responding

Postby AshishNehete » 20. October 2011 11:08

yaa the host file fix!
AshishNehete
 
Posts: 11
Joined: 20. October 2011 05:53
Operating System: Windows 7 32 bit

Re: #2002 - The server is not responding

Postby Sharley » 20. October 2011 11:12

Great news as it helps others looking for the solutions and it helps us narrow this beast of an issue down a little further. 8)

Best wishes and good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests