Sounded like he lost one password, not the root pass? You should be able to edit by just entering the same username in mysql (from the cpanel link) and creating a new password. It should overwrite the existing one. Remember to change any connection scripts to use the new one as well, or they will fail.
Having problems, or maybe questions about WHT? Head over to the help desk!
If your looking for a quick resolution it's best just to recreate the mysql user in cPanel - I believe mysql passwords have to be reset by root.
Hope this helps
Yeah, im pretty sure the reset would have to be done via the root user.
But if you delete / recreate the user, it should work. Or you can create a totally new user for the database. It wont lose any of the data, it will just be like adding a new user to an existing database.
I probably wouldn't be messing with the mysql login details through WHM itself, it's best to create a new user in the cpanel area of the account in question, which you access either from whm in the list accounts page, or by logging into the cpanel account directly. Create the user and add it to your database, it's possible to have more than one user on a database as well if you don't want to mess with the one you setup already.
Webcave Hosting - Today's Gateway to Perfect Hosting!
*Non-Oversold Shared hosting *Dedicated Servers *Web Design *Domain Names 24/7/365 LIVE Technical Support/Sales via phone, live chat, email and ticketing system.
30-Day Money back guarantee, 99.99% uptime SLA. - WebCaveHosting.com
help...why can't I access my cpanel at all? My welcome page says login to cpanel gives me a password, but, to date I can't get in....
You will want to contact your hosting provider to get that password reset, unless you have access to WHM as root. If this is the case then you would be able to change the password by logging in as root >> Account Functions >> Password Modification
Most welcome letters that I have come across for VPS only contain the root password and not the cPanel account information so you could be trying to login to cPanel as root which will not work.
As for the MySQL database issue, I would have to agree with everyone else that creating a new user and adding it to the database is the best route to go. Then just delete the old user and update your configuration files to use the new user/pass combo.
If you are having your server root login details then follow following steps carefully from shell.
1st login in to shell as root user now run command( For example I am using site/domain name as test.com and user test.
It will give you user name, now switch to user account.
Now you are in test user home directory under which all hosting files are present.
Run command to search database user and password.
grep test_ * -R -l
Above command will show you all files under which database name/user name is defined.
Now you have to open config file, you have received after running above command.
One config file open search for database user name and password.
login in to cPanel select mysql database feature and add database user with the password which you have found out in config files and reassigned privilege for newly added database user to existing database.
Could you not, I don't know... just look into the configuration (config.php) of said script to obtain current MySQL password?
Example, if you lost your database details for a Wordpress blog, just look up the details in the config.php and save yourself the hassle of having to change that exact same line of information after you've made the update.
vpsBoard - An active resource for all things Virtual Private Servers. Tutorials, Guides, Offers and more!
Come join the conversation! 90,000 posts and growing daily! The fastest growing hosting forum around!
The database does not physically have a password, it is the user assigned to the database that uses the password, if you are using cPanel simply remove the user from the database and then re-create that user with another password.
You can change the passwords as required within phpMyAdmin or view the config.php as recommended.
██ l Dedigeeks (Twitter) Shared Reseller Cloud VPS Since 2010
██ l Leading AU Hosting Provider Multiple locations - around the globe!
██ l cPanel/WHM R1Soft Backups 24/7/365 Support 99.9% Uptime Guarantee
██ l www.yourcompanynamehere.com Customer Service Rep. Superior Service Guarantee