[Answered] Mysql Server Passwords Messed Up, Can't Login

[tcwwt]

Recently my php scripts to access a MySQL database have stopped working. All pages that try to do this only show an error saying that it can't log into the MySQL server. When I tried going into phpMyAdmin, I got a 1045 error.

I tried changing the password for the database user, but it wasn't recognizing the old password. I then made a new user and added it to the database, and tried again, but no luck. (when I tried changing the password for the new user, it also told me the old password was invalid)

I've no idea what's going on with the password system, but nothing seems to be working...

Any suggestions?

Thanks

[wolstech]

Thats odd...

 

Try changing your cpanel password. On the password change page, make sure you check the "Allow MySQL password change" option if its not already checked. That might fix phpmyadmin. If phpmyadmin works again, try recreating your database users to fix them.

[tcwwt]

I tried this, but I can't even change the cpanel password (supposedly based on a dictionary word...does this just mean I have to come up with a random password?)

[wolstech]

That's exactly what it means. Needs to be something that's not in the English dictionary. Frustrating at times, but provides extra security.

[tcwwt]

Okay, it worked, I now have access to phpmyadmin

Thank you so much!