How can I find a list of database-users WITH their passwords on cpanel also I need to be able to update the password of an already existed user on a database? I have looked at all the options on myphpadmin and mysql which are offered on cpanel but couldn't find the actual passwords for the database users. I need to update the password of a user on a database to match the config file. please help
The passwords are not recoverable. Do you have admin/root access to the database? If so you can just update the user's password with one you know.
To make this a bit more clear, the database itself created by me (webmaster) and as you know when we create any new database we need to add a user name and a password in which they become db_username and db_password in the config files, this password in the cpanel should be saved somewhere so that we can update it when we need it. hope it is clear now... thanks