How to Solve the XAMPP 1.7.7 - PHPMyAdmin - MySQL Error #2002 in Ubuntu

Question

I have been through lots of forums and checked various posts on similar topic but non seems to work out for me.

I have freshly installed XAMPP 1.7.7 on my Ubuntu 11.10 Operating system. Everything is running except for the phpMyAdmin.

Upon hitting: http://localhost/phpmyadmin, I am getting the following 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.

When i am starting the services with: sudo /opt/lampp/lampp start
I am getting the following:

XAMPP: Another web server daemon is already running.
XAMPP: Another MySQL daemon is already running.
XAMPP: Another FTP daemon is already running.
XAMPP for Linux started.

Any suggestions would be greatly appreciated.

Solution 1

It turns out that the solution is to stop all the related services and solve the “Another daemon is already running” issue.

The commands i used to solve the issue are as follows:

sudo /opt/lampp/lampp stop              
sudo /etc/init.d/apache2 stop    
sudo /etc/init.d/mysql stop

Or, you can also type instead:

sudo service apache2 stop
sudo service mysql stop

After that, we again start the lampp services:

sudo /opt/lampp/lampp start

Now, there must be no problems while opening:

http://localhost                  
http://localhost/phpmyadmin

Solution 2

1. Open config.default.php file under phpmyadmin/libraries/
2. Find $cfg['Servers'][$i]['host'] = 'localhost'; Change to $cfg['Servers'][$i]['host'] = '127.0.0.1';
3. refresh your phpmyadmin page, login

Solution 3

At each point in these instructions, check to see if the problem is fixed. If so, great! Otherwise, continue.

1. Get to Services. (I was able to right click the Apache launch icon to get there.)
2. Scroll down to MySQL. Click to start. This will get rid of the #2002 error. Now you'll have a new error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

1. Edit the C:\wamp\apps\phpmyadmin3.5.1\config.inc.php file, changing $cfg['Servers'][$i]['extension'] = 'mysqli'; to instead be= 'mysql'
2. Open Services again and Stop MySQL
3. While in Services, Start wampmysqld

This is convoluted, I know, but that's what worked for me. Some posts may say you need a password in the config file, but you don't. Mine is still ""

Hope this helps.

Solution 4

I stopped MySQL sudo service mysql stop and then started xammp sudo /opt/lampp/lampp start and it worked!

Solution 5

The problem might be with service mysql-server and apache2 running while system start. You can do the following.

sudo /opt/lampp/lampp stop

To stop already running default services

sudo service apache2 stop
sudo service mysql  stop

To remove the services completely, so that they won't create problem in next system-restart, If you are in ubuntu(debian)

sudo apt-get remove apache2
sudo apt-get remove mysql-server

If you are in redhat or other, You could use yum or similar command to uninstall the services

Then start the lampp again

sudo /opt/lampp/lampp start

Also, don't install mysql-server in the system, because it might start in system start-up, occupy the port, and create problem for mysql of lampp.

View more solutions

Comments

[Raptor]

check: is your mysql service started ?

[CompilingCyborg]

Absolutely it is! After the command: /opt/lampp/lampp start

[CompilingCyborg]

I can't find the mysql.ini file at all in my opt/lampp directory. I did search recursively in this directory for the file but found nothing. Could it possibly be of different name?

[Netorica]

that was my same problem in my windows box... very same error message that's why i just posted it as my answer. is there any opt/lampp/mysql? directory?

[CompilingCyborg]

Thanks for your help through this. My operating system is Ubuntu 11.10. No actually there is no directory of opt/lampp/mysql. I think the linux version of XAMPP 1.7.7 has different way of arranging the files and folders.

[SparK]

the OP was specific about the OS being ubuntu and not windows

[Naguib Ihab]

@surajmishra I am getting command not found for: sudo service apache2 stop sudo service mysql stop And I'm also getting unrecognised service for sudo service apache2 stop sudo service mysql stop

[Naguib Ihab]

I am getting command not found for: udo apt-get remove apache2 sudo apt-get remove mysql-server And I'm also getting unrecognised service for sudo service apache2 stop sudo service mysql stop

[psvj]

you need to add a "/" to the first command so that it reads: sudo /opt/lampp/lampp stop. not the current sudo opt/lampp/lampp stop

[jameshwart lopez]

its not working in my case. I have stop and start but its not working. the same error

[Habib Rehman]

Hi there, so does it means that we have installed mysql at two points ? and when first point stop (sudo service mysql stop) The mysql of (sudo /opt/lampp/lampp start) works in. How do i get rid of it permanently ? I need to uninstall linux service of mysql

[newbie]

I don't think this is blocked by mysql service, oh I wasted 2 days for this.

[Niroj Shr]

Thank you. I too was having the conflict of xampp and lampp The solution made my day :)