Web Hosting Talk : Web Hosting Main Forums : Web Hosting : Web Hosting Tutorials : Lost mysql password, how to change in WHM/cpanel?

[kenigmatic]

I have lost my password for a mysql database.
I am planning to move site/s to another server.
How to change in WHM/cpanel?

[Crucial Web Host]

Hi Kenigmatic,

Simply log into WHM and scroll down and find SQL Services. In that section you will find a link to reset your root password for MySQL.

Kindly,

If you dont have access to cpanel and you're just trying to reset a passwod for a a local dbuser. Log into cpanel and go to databases. From there you can just change the password for the db user.

[bear]

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.

[urevisedhosting]

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

[shankdigital]

Originally Posted by urevisedhosting

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.

[inspiron]

You will need the root access to change the password through WHM >> SQL Services >> Change Mysql user password or you can get change it through the cPanel >> MySQL Databases.

[Everything]

I've had a lot of trouble with this in the past, it's good to see some support on this.

[CanHasHost]

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.

[tiaratext]

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....

[Setup Link]

login to phpmyadmin or to your root mysql account via SSH and create a new user with access to your database. If you cant access cpanel you need to change your root pass on your account or vps

[GORF]

Originally Posted by bear

Remember to change any connection scripts to use the new one as well, or they will fail.

Just look in the script! You say you have access to cPanel. Look in the database connection script.

[HFWMikeM]

Originally Posted by tiaratext

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.

Mike M.

[webdesignnet]

+1 for Crucials suggestion

[sanseo]

Originally Posted by inspiron

You will need the root access to change the password through WHM >> SQL Services >> Change Mysql user password or you can get change it through the cPanel >> MySQL Databases.

yes this is right way, You can change it whm or cpanel, both have access if you want to change multiple website a/c than use whm..........

[DxSEO]

If you have WHM panel password then you can reset it bt yourself if you are owner of that hosting without any problem