What SQL DB name is being used plus resetting password

[seburbansu9fb0]

Hi guys again, the comany uses magento 1.9, I need to move hosting company. 2 biggish problems.

1) I have a have a list of SQL DBs', how do I know which one the live magento is using?? probably either of the 2 biggest ones, however need to be sure.

2) Usernames and password, after I have located the username used, I need to reset the password, doing it in sql is easy, however I will need to reset it in magento. How is that done??

Regards Seb

[gaurav_harsh1 · Accepted solution]

Hello @seburbansu9fb0 ,

You can find the environment details for Magento 1 inside :

Spoiler

/<Magento Install Dir>/app/etc/local.xml

Here you can find your db name, db host, db username, db password.

Magento only stores these details to communicate Magento with database, it doesn't store your db details anywhere else, so after changing password in mysql, simply update password in the above file.

Hope it helps !