Changing Database Password

[Len98]

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!

[Mukesh Tiwari]

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.

[Len98]

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.

[Len98]

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. 

[Lag_T66ACE]

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!

---