Xampp localhost/phpmyadmin error

Question

Every time I try to access my localhost/phpmyadmin it gives me this error ---> Error MySQL said:

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.

Please I really need your help, I'm clueless. Below is my config.inc.php file Thanks a lot for your help!

<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; 

/*
*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'] = false;

/* 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
*/

?>

No, it stops after about 3 secs every time I start it. Any suggestions on what I could do? — non-userlololol
– non-userlololol, Commented Jun 25, 2012 at 1:28
It doesn't seem like an issue with phpMyAdmin, check your MySQL logs (xampp\mysql\data\mysql_error.log) or try running mysql.exe in the command line and check what it says. — Mahn
– Mahn, Commented Jun 25, 2012 at 1:38
for some reason, I can't find mysql.exe on my computer, was i suppose to install mysql separately from xampp?? — non-userlololol
– non-userlololol, Commented Jun 25, 2012 at 1:49

Jocelyn · Accepted Answer · 2012-06-25 01:24:51Z

1

From the Mysql documentation:
The error (2002) Can't connect to ... normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.

answered Jun 25, 2012 at 1:24

Jocelyn

11.4k11 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anirudh Ramanathan · Accepted Answer · 2012-06-25 01:52:58Z

0

On a linux system, you should add the following to your config.inc.php

$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.sock';
    or
$cfg['Servers'][$i]['connect_type'] = 'tcp';

On a windows system,

 $cfg['Servers'][$i]['socket'] = "c:/tmp/mysql.sock"

The same changes must be reflected in your xampp\mysql\bin\my.ini file as well.

edited Jun 25, 2012 at 1:52

answered Jun 25, 2012 at 1:20

Anirudh Ramanathan

46.8k24 gold badges137 silver badges195 bronze badges

9 Comments

Anirudh Ramanathan Over a year ago

Did you change it in the my.ini file as well?

non-userlololol Over a year ago

I can't find the my.ini file, is it in the same directory??

Anirudh Ramanathan Over a year ago

You might be better off completely removing XAMPP, including installed directories and reinstalling it then, rather than finding the error. Make sure you have no other MySQL instances running.

non-userlololol Over a year ago

ok, I'll give that a try. Pls how can I check if there is any other MySQL instance running??

Anirudh Ramanathan Over a year ago

It might have been installed in the past and lying dormant :) Just check your installed programs and your Program Files directory.

|

Shoib Mohammed A · Accepted Answer · 2013-01-06 06:51:28Z

0

I too got same error when i tried to open phpmyadmin, i removed mecafee from my system then i restarted the system, from then it was working fine, may be mecafee(anit virus) was the problem... Hope it works for you...

answered Jan 6, 2013 at 6:51

Shoib Mohammed A

3384 silver badges13 bronze badges

Collectives™ on Stack Overflow

Xampp localhost/phpmyadmin error

2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

3 Answers 3

Comments

9 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

3 Answers 3

Comments

9 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related