cancel
Showing results for 
Search instead for 
Did you mean: 

What SQL DB name is being used plus resetting password

SOLVED

What SQL DB name is being used plus resetting password

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.

SQL DB.jpg2) 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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: What SQL DB name is being used plus resetting password

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 !

 

Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !

View solution in original post

1 REPLY 1

Re: What SQL DB name is being used plus resetting password

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 !

 

Problem Solved ? Click on 'Kudos' & Accept as Solution to encourage to write more answers !

View solution in original post