cancel
Showing results for 
Search instead for 
Did you mean: 

Changing Database Password

Changing Database Password

Hello,

 

Could you please advise on how to change my database password correctly?

I believe I have to change it through phpmyadmin and then I need to locate a config file through FTP. I can't locate the file. Could you please advise where exactly is the file and if something else needs to be edited?

 

Thank you very much!

 

 

4 REPLIES

Re: Changing Database Password

Hi @Len98

 

If you have access to command line SSH and you are root user?

Do you want to update the existing user password?

 

If yes then try following

 

mysql -u root -p

Now switch to the appropriate MySQL database with the following command:

use mysql;

Be sure to replace your_new_password with the actual new password:

update user set password=PASSWORD('your_new_password') where User='username';

Then run following

flush privileges;

NOTE : If you are not familiar with command line and not sure how to do it. Seek professional help before doing it on production site.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: Changing Database Password

Hello,

 

Thank you. Yes, I am the root user. But it doesn't work for me. I tried to follow the instructions and can't do it. Would you please give me detailed step by step if possible? I am really new to this and don't feel really comfortable in phpmyadmin environment yet.

 

Thank you.

Re: Changing Database Password

I can change the password through my cpanel by creating a new user but I need to change it through FTP as well. 

Could someone advise on what file needs to be edited through FTP please? What is it called? I can't locate it.

Thank you in advance. 

Re: Changing Database Password

Hi, I need to change my DB password via phpmyadmin.
How can you proceed before editing the local.xml file (access via FTP)?
Thank you

Len98 wrote:

Hello,

 

Could you please advise on how to change my database password correctly?

I believe I have to change it through phpmyadmin and then I need to locate a config file through FTP. I can't locate the file. Could you please advise where exactly is the file and if something else needs to be edited?

 

Thank you very much!