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

User · Answer

Go to phpMyAdmin config inc php edit the line    cfg  Servers    i   password           to   cfg  Servers    i   password      yourpassword     This problem might occur due to setting of a password to root  thus phpmyadmin is not able to connect to the mysql database   And the last thing change   cfg  Servers    i   extension      mysql     to    cfg  Servers    i   extension      mysqli     Now restart your server  and see

User · Answer

Goto xampp folder in local drive c  click on mysql folder  then click on bin and finally click on  mysqladmin  application  Then go back and refresh your browser and the problem is solved

User · Answer

You can check it by connecting MySQL through the command prompt   I think that your MySQL Database is blocked by firewall  Once stop all the services of antivirus software you have on your computer  then try to connect   I faced this problem as well and rectified by blocking all firewalls

User · Answer

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

User · Answer

please check the mysql ini file in your xampp mysql installation    its found on xampp mysql bin directory  check the line 43   gt  log error  mysql error log   gt   bind-address  127 0 0 1    uncomment the line 43 if its still commented

User · Answer

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

User · Answer

At each point in these instructions  check to see if the problem is fixed  If so  great  Otherwise  continue    Get to Services   I was able to right click the Apache launch icon to get there    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     Edit the C  wamp apps phpmyadmin3 5 1 config inc php file  changing  cfg  Servers    i   extension      mysqli   to instead be   mysql  Open Services again and Stop MySQL 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

User · Answer

Open config default php file under phpmyadmin libraries  Find  cfg  Servers    i   host      localhost    Change to  cfg  Servers    i   host      127 0 0 1   refresh your phpmyadmin page  login

User · Answer

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

User · Answer

Go to config inc php file using terminal by typing the following   sudo gedit  opt lampp phpmyadmin config inc php   The file will open in gedit   Now open the file and edit   cfg  Servers    i   auth type      localhost     to   cfg  Servers    i   auth type      cookie     and keep the username as  root password    Also make sure that the lines with username and password are not commented      cfg  Servers    i   user      root      cfg  Servers    i   password           Make sure that    is removed from the above lines

User · Answer

Though I m using Mac OS 10 9  this solution may work for someone else as well  perhaps on Ubuntu   In the XAMPP console  I only found that phpMyAdmin started working again after restarting everything including the Apache Web Server   No problemo  now

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

Examples related to mysql

Examples related to ubuntu

Examples related to phpmyadmin

Examples related to xampp

Examples related to mysql-error-2002