#1045 Cannot log in to the MySQL server

Follow @tristarweb

I was trying to access PHPmyadmin via my cPanel earlier for one of my web design projects, and came across the following error: #1045 Cannot log in to the MySQL server. I was baffled. It turns out the solution was actually really simple, and all I did was the following:

  1. Log in to your cPanel account.
  2. Under Preferences, click Change Password.
  3. Type in your old password, and enter a new password (I had to enter a series of letters and numbers, so as not to make a dictionary word).
  4. Make sure Allow MySQL password change is selected.
  5. Click Make Password Change Now!.

After following the steps above you should now be able to log in to your PHPmyadmin via cPanel! I hope this helps someone out.

About James

Hello there, I'm James. I studied Multimedia Design at university. I'm a designer at heart, though I love developing innovative and exciting solutions to web based products.I now specialise in front end web design and bespoke Wordpress powered websites.

3 Responses to #1045 Cannot log in to the MySQL server

  1. Syafiq Zainal says:

    03:12 03/03/2011

    You help me mate! I want to cry after cannot access my phpmyadmin with the old username n password. Now i can n a big thanks for u! :)

  2. Derek says:

    13:38 19/08/2011

    I’ve been using cPanel for years and have never seen this phpadmin login before!
    Thanks for this, have been head scratching for a few hours. :)

  3. aldwin says:

    06:59 06/09/2011

    Weird. Just had this error with FF but not in IE. Cleared my cache and is now working. I’m using phpMyAdmin for years and this is the first time I encountered the error.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Please wrap all source code with [code][/code] tags.

Follow Tristar on Twitter