I realize this is an old thread but I’m having trouble with this same issue and maybe someone can help. Have followed all the suggestions here with no luck. I tried creating both a mySQL4 and a mySQL5 user and I still have the same problem. Have checked and rechecked (and rechecked) the relevant lines in the wp-config file. Still no luck.
Question: I’m confused about how to use the OLD_PASSWORD trick mentioned above since I don’t have the ability to go to my web host and find an MySQL> prompt. It doesn’t work that way. I can create a mySQL user and a database, but there’s no opportunity to do anything with it through the webhost. How do you do that?
Sorry for being so thick, but I’ve just spent hours going through the forums and I must be misunderstanding something. Where does the SET PASSWORD FOR some_user@some_host = OLD_PASSWORD(‘your_old password_here’); text go??
