I recently change database username password from c-panel and now when i open website or admin panel it shows error.how to resolve this issue? how can i add new password in magento database? or what can i do?


Changing database username and password isn't the right thing to do as the changes will not be effected in the config file, you should have just created a new user and assigned it to the database with full privileges.

You'll have to look for your config file in your cpanel and change the username and password there to the new ones Location to the config file i: /app/etc/local.xml Edit local.xml file, locate your database and the necessary details. The file looks as shown below

false 1

  • thanks for your reply , i did as you mention , create new user with all privileges and update in local.xml , and flush cache but it did not work – Syze Developer Jun 4 '20 at 10:20
  • You should check your cpanel for errors log to know the exact cause and more importantly the error code, that'll help to find the perfect solution – AYC Jun 5 '20 at 17:30

Not the answer you're looking for? Browse other questions tagged or ask your own question.