Friday, March 25, 2011

#2002 Cannot log in to the MySQL server

If you're getting "#2002 Cannot log in to the MySQL server" when logging in to phpmyadmin on mac os, try editing phpmyadmin/config.inc.php and change:
$cfg['Servers'][$i]['host'] = 'localhost';
to:
$cfg['Servers'][$i]['host'] = '127.0.0.1';

Did the trick for me (after spending 2 hours on it).
Posted by at

11 comments:

  1. DKNovember 3, 2012 at 12:25 PM

    Thank you! I've spend nearly 1 hour too. Until happened to spot your post.

    ReplyDelete
  2. OBLSKNovember 3, 2012 at 2:35 PM

    Sure thing, I'm glad it helped

    ReplyDelete
  3. UnknownNovember 4, 2012 at 5:28 AM

    thanks! you save my day

    ReplyDelete
  4. LilyDecember 4, 2012 at 9:04 PM

    I appreciate your help. you save my time as well.
    I search around web and only find yours work.

    ReplyDelete
  5. UnknownJanuary 27, 2013 at 11:39 AM

    Thanks so much this worked

    ReplyDelete
  6. UnknownSeptember 20, 2013 at 5:59 AM

    i cant find editing phpmyadmin/config.inc.php so please tell me what the solution this problem exactly and i am using win7 os

    ReplyDelete
    Replies
    1. OBLSKSeptember 20, 2013 at 8:56 AM

      Hi Milind,
      Sorry I don't have the answer for this one, I've never actually tried to run it in a Windows environment. If you figure it out though I'd really appreciate you posting the solution here as I am sure someone else could benefit.

      Thanks,
      Ryan

      Delete
  7. AnonymousJuly 10, 2015 at 6:58 AM

    This helped me as well! thank you very much

    ReplyDelete
  8. ikanyuSeptember 10, 2016 at 12:59 PM

    you save my life

    ReplyDelete
  9. UnknownNovember 13, 2018 at 3:06 AM

    https://srilankatravelhub.com/

    ReplyDelete
  10. Johnson 90December 22, 2018 at 1:04 PM

    You can also SET SESSION and SET GLOBAL query, in case if you want to make a change while the MySQL is running. dbdesigner.net

    ReplyDelete

Subscribe to: Post Comments (Atom)