Register
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Jun 2011
    Posts
    24
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default Ubuntu, MySQL "#2002 Cannot log in to the MySQL server"

    I have a website that is hosted off my linux desktop, I use the MySQL for a guestbook and stuff but recently when I try to log in to PHPMyAdmin it says "#2002 Cannot log in to the MySQL server" and everything that uses MySQL says "Cannot Connect to Server" I tried "sudo service mysql reload", tried restarting apache2, restarting my computer even changed "localhost" to "127.0.0.1" in the config.inc.file thing then reloaded everything again, but still nothing works. Does anyone have any ideas or suggestions? I have been googling all morning.
    Check out my website

  2. #2
    V.I.P. Member
    GastonJ's Avatar
    Join Date
    Dec 2009
    Posts
    5,505
    Thanks Thanks Given 
    836
    Thanks Thanks Received 
    1,676
    Thanked in
    1,083 Posts

    Default

    Is mysqld actually starting and running? Try

    /etc/init.d/mysql status

    to check on the status and work from there. If it is running try a manual connect, I assume you have the mysql client installed? with:

    mysql -u username -p

    enter the password and you should be ok. If that all works, then you may need to reconfigure PHPMyadmin. I normally use Webmin rather that PHPMyAdmin out of preference.

    HTH
    My master plan is to live forever..... going to plan so far
    Despite the cost of living, it's still very popular.
    No good deed goes unpunished....


 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.