Can't access my wordpress database at all

[considerphi]

Hi , I can't access my wordpress database at all, even through phpMyAdmin.
It used to work and then it stopped. I tried to upgrade wordpress through fantastico and fantastico couldn't access the database either. I got this error:

Upgrading...​

Initializing Parameters - Done.​

Upgrade failed
The database scarvalh_wrdp1 is not working properly and the creation of a database backup file has failed. Please contact the sysadmin for further assistance. Include this message for reference.
The initial installation has not been modified.


My username is scarvalh, the database is scarvalh_wrdp1 as noted above. Thanks for any help... sorry if this has been answered elsewhere, I did search but since I can't access the db through phpMyAdmin I can't even begin to fathom how to fix it.

-s

 

[Corey]

I checked briefly in the MySQL section of your cPanel. There are no users assigned to that database, that would be your issue. I added the user that was there to it assuming it was the correct one.

User scarvalh_wrdp1 was added to the database scarvalh_wrdp1.

Can you see if it's working now?

 

[considerphi]

Oh cool thanks, now I can access it through phpMyAdmin. Just one thing... I don't know the password for the new user you created and I can't recreate the user and set the password myself because the MySql section only allows me to make 7 character names. I can't find any user management within phpMyAdmin.

How do I get around this? Thanks so much for your help!

-s

 

[Fedlerner]

The password of the user Corey has added is the one you've in your config.php file.
When you create a database/username it will always be: YOURCPUSERNAME_NAME, where YOURCPUSERNAME would be your cPanel username and NAME would be the name you've chosen for the username/database.
When Corey created the database, he just put: wrdp1 in the username.