Changing database password

[Markstar]

Hi,
today I lost my USB stick that had a mirror of my website on it. Most passwords were encrypted, but the configuration file for the database connection was obviously not, so now I would like to change it. Problem is, I don't see anywhere where I can do this. :dunno:

Thank you in advance!

 

[DeadBattery]

If you want to change the password for the user that has access to the database, login to cPanel and click on MySQL Databases.
To change the password, you'll have to delete the user, and re-add it selecting a different password and assigning the same privileges.

 

[Markstar]

Thanks. I was thinking about this, but thought I'd ask first if there is no other way.

 

[Gouri]

Thanks. I was thinking about this, but thought I'd ask first if there is no other way.

What ever DeadBattery said it is the good option. Remember to backup first then delete only user and re create it.

 

[Zubair]

What ever DeadBattery said it is the good option. Remember to backup first then delete only user and re create it.

No need to backup database. Just delete user and recreate it. Leave the database as it is..

 

[Markstar]

Well, backing up a database is always a good idea, I guess. I shall do that anyways. I had hoped to learn how to set up cron jobs for this so that I get an email once a week with the backup, but I had no time so far so I'll do it by hand.

Thank you guys for your replies!

 

[Gouri]

No need to backup database. Just delete user and recreate it. Leave the database as it is..

It is for safety, If something goes wrong then he will be having backup.

 

[descalzo]

It is for safety, If something goes wrong then he will be having backup.

Nothing can ever go wrong.

rm -fR *

:biggrin:

It is a very good habit to get into. Backup before major edits, etc. And then periodic updates (mainly databases for those using a CMS) stored in a different location (one on your local computer and maybe one stored in your Gmail account).