Can no longer sign into wordpress by accidentally changing phpMyAdmin password

  • As the title says, I can no longer sign into wordpress. I had no problems signing in and working on my page, but today I accidentally changed my phpMyAdmin password and, as such it no longer corresponds with the MySQL password. I can’t get into PhPMyAdmin to change it back! I received the following error:

    MySQL said: Error #1045
    Access denied for user root@localhost (using password: YES)
    PhPmyAdmin tried to connect to MySQL server, and server rejected the connection. You should check the host, username and password in your configuration.

    ^ How do I do this!?!

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi Dr. -A,

    Your phpAdmin credentials just allow you to manage MySQL databases. These don’t have to be the same as credentials that get you into a MySQL database.

    If you’ve locked yourself out of phpAdmin, you’ll need to reach out to your hosting provider (or whomever manages that) to help.

    Thread Starter Dr. -A.

    (@dr-a)

    Hi dbough,

    I am running my site via local host on my own computer (a Mac) using MAMP.
    Is there any way to manually change MySQL Super Privileges?

    I attempted to reset password by going into Mac terminal and writing “/Applications/MAMP/Library/bin/mysqladmin -u root -p password”

    This gave me the response “can’t turn off logging; error: ‘Access denied; you need (at least one of) the SUPER privilege(s) for this operation’

    Any ideas?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can no longer sign into wordpress by accidentally changing phpMyAdmin password’ is closed to new replies.