Do i really have to know my SQL database passowrd?

Hello,
I have a few sites of which i do not know the password....does it really matter?
I usually just generate a password and just forget about it.

is there a way to recover my sql password?

thanks in advance.

 

Ofcourse it matters.. If you have cpanel, go to databases or mysql and you can change it there per site.

 

You have used those passwords in webpages , you get it from there . Most of the control panel woun't show the passwords and you have to update.

 

i have the same question
how to recover lost mysql password?

 

No way to recover a lost password. You can change the password provided you have access to the root user or a user with GRANT access.

 

and how do i do that?

 

Hi,

Best way if you contact your hosting company support team. They will be reset your password or explain how to reset password.

Rudolf

 

when reset by host, do i lose all information?

 

No, they will just give you a new password. If you have any scripts/sites using that db, you will then have to update the pw in the config file. (Though if you do, you can just see the current pw in the config files of those scripts..)

I believe you can also just reset the password in cpanel > mysql.

 

Hi,

You don't loose anything. You or provider just reset your password's. After changing password you need update configuration files with new password. If you don't now in which file you need change your database password let me now. I will be found out for you. Just write me down which application use in your web site.

Rudolf

 

provider = my host right? can they really do it? if reset, how do i change the pass?

i'm running different scripts, but after installing it, i deleted the config.php file already, so how do i change the password from that script as well?

 

Hi,

Yes, Provider = your hosting company. They can do anything with your web hosting. They have complete administrator right to your account.

To change your database password in your script you need to find the configuration file. Mostly you can find in include directory but different script storing in different place.

Example:
- WordPress store database password in wp-config.php file. In wp-config.php you can find “define('DB_PASSWORD', 'old password'); line and you need change 'old password' to 'new password'.

Rudolf

p.s. One idea if you find and check your configuration file actually you can recovery your password. Mostly in configuration file store password in plain text for database.

 

thanks Rudolf, i found my config file with my password.

Now...going off topic, how would i go about backing up database and restoring it later on? like sometimes files go corrupted or server get hacked or something..u know

thanks everyone for helping out

 

Hi,

You have lot of option to backup database.

If you have command prompt access to your server than is a best way to write one script which backup your database and your web site to temporary directory. After that compress temporary directory and send with ftp program to your home machine or your backup server. Don't forget schedule your script to backup your server minimum one time per day.
if you don't have command prompt access then you can use maybe your web site Control Panel (cPanel) or PhpMyAdmin.

Rudolf