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

[gendjik]

just create another user for that database from mysql tab, then you should adjust the connection properties with that new user on your script/software

[linux7802]

Hi,

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.

/scripts/whoowns test.com

It will give you user name, now switch to user account.

cd ~test/public_html
or
cd /home/test/public_html

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.

<<snipped>>

Awaiting for your reply.

[qtriangle]

It is strange that you can not reset the mysql password from cpanel.
Why shouldn't I be able to do that if I have created the user through cpanel?
Looks like a feature suggestion for cpanel.

[RadicalBro-Dylan]

Hi,
If you lost your root SQL password there is an option in WHM to change it.

Dylan,

[somasarkar]

Can anyone please tell me what happens if I REMOVE those two passwords from that file? What apps on the system actually use or rely on them?

[MannDude]

Is the database being used by any active scripts?

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.

[Sparrow-Sean]

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.

[bstephe]

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.

[chetansoni]

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.

[magucr]

so if users need to reset their mysql password trough their cpanel they need to know the old password? this is just plain stupid.

[bear]

Originally Posted by magucr

so if users need to reset their mysql password trough their cpanel they need to know the old password? this is just plain stupid.

Cpanel/WHM password is not the same as the mysql root pass.

[magucr]

Originally Posted by bear

Cpanel/WHM password is not the same as the mysql root pass.

huh? and whos saying that?

[whfm]

When you click on change password, there is a buttom called sync passwords with mysql, click that and then job done,

OR

You can do what another user has said and make a new user in mysql.

[magucr]

I know that, thanks but I am not asking for help, I am just criticizing the fact that you have to know the old password in order to reset it. It does not make any sense.

Also, It is not a good idea to have both cpanel and mysql passwords synchronized, It's actually a documented security issue.

[unique-links]

login to cpanel and from there change the pass word easily, of your db username, you can change all the passwords, if you can solve it, re create the mysql database..