After pulling some hair out for an hour I thought I would pass on a solution I found.
I tried pretty much everything up here, but nothing worked.
For those using cPanel, this might be something good to know.
I tried to name my database using underscores like ‘my_wordpress’ well Cpanel took the name fine but showed it as ‘user_mywordpress’ which is fine so I plugged that in thinking it stripped the _ (underscores) from the string. Turns out it didn’t. As soon as I deleted that database and created a new one called ‘mywordpress’ and created a new user and password (for good measure) and assigned it to the new database, it worked. I am running MySQL 5.0.51a
Hope it helps someone. I actually was inspired to check the database name when i visited this link:
