Reset MySQL db password

[mobcdi]

I am running
cPanel Version 11.24.5-RELEASE
cPanel Build 38506
with
Apache version 2.2.13 (Unix)
PHP version 5.2.10
MySQL version 5.0.81-community

and can't find how to reset the password for an existing MySQL account, the MySQL screen allows to

1. Add new database user
2. Add user to a database

But there doesn't seem to be an option to reset the dbpassword, I've also tried via phpmyadmin and the cpanel account logged in with doesn't see the privileges tab.

Is there a package feature I need to include to allow MySQL password resets?

[thewebhosting]

There is no option to reset the database user from PHPMyAdmin as well as from cPanel. However, you can try to delete the database user from the cPanel and recreate it.

[cPanelDavidG]

To change a password for a MySQL virtual user (a MySQL user created via cPanel), just create the same user again. The new user will overwrite the old user, and replace the old password in the process.

[mobcdi]

Is there a way to test the MySQL account details to make sure the password I think is for the user is actually correct thus ruling out the uncertainty before actually using the accout details outside of cPanel?

[mobcdi]

I deleted the user account and added it back again and gave "All previliges" to the db.

But I still can't use the account to connect to the db, the cms I'm trying says

We were able to connect to the database server (which means your username and password is okay) but not able to select the database.
Are you sure it exists?
Does the user have permission to use the database?

I've tried readding the privileges via cPanel but the error continues.

[mobcdi]

When i check the db via the host account I've found that the MySQL account I created using the cPanel wizard isn't given all privileges and is missing

• Create View
• Show View
• Alter routine
• Execute
• Grant

Grant is also listed as No,

There is another DB user named after the cPanel account which has All privileges to the database I created with the database wizard

Could there be 2 user accounts created as part of the wizard?

[cpanelkenneth]

When i check the db via the host account I've found that the MySQL account I created using the cPanel wizard isn't given all privileges and is missing

• Create View
• Show View
• Alter routine
• Execute
• Grant

Grant is also listed as No,

There is another DB user named after the cPanel account which has All privileges to the database I created with the database wizard

Could there be 2 user accounts created as part of the wizard?

The All Privileges option in the cPanel MySQL interface only grants all privileges displayed in the interface.

[cPanelDon]

There is another DB user named after the cPanel account which has All privileges to the database I created with the database wizard

Could there be 2 user accounts created as part of the wizard?

The Wizard only creates one MySQL user to my knowledge.

What is the formatting of the two usernames?

For example:
1.) username_dbuser
2.) username

Regarding the additional privileges we are aware of the need and have the following related internal case IDs:
#17834
#31333

[mobcdi]

Yes the usernames follows the structure you outlined. I still can't place what exactly I was doing wrong but decided to delete the account via whm and recreated it entirely which seems to have cleaned my brain and the system

[BianchiDude]

The All Privileges option in the cPanel MySQL interface only grants all privileges displayed in the interface.

Well, then why doesn't the interface have:
Create View
Show View
Alter routine
Execute
Grant

[cpanelkenneth]

Well, then why doesn't the interface have:
Create View
Show View
Alter routine
Execute
Grant

Donald already addressed this in his post.