Changing MySQL Database Password

  • Resolved Anonymous User 9948090

    (@anonymized-9948090)


    11 years, 11 months ago

    Hello everyone

    When we install WordPress for the first time on a blog, we create new database, new user and set a new password for it. We give the same details in wp-config.php file.

    Now I want to change database password but I’m worried that nothing should go wrong while doing this. So I need your expert advice.

    Which are the places which contain database password details and which places should I change to change the db password.

    According to my knowledge, I should do as following:

    1. First change db password using cPanel -> Databases -> MySQL Databases. Here it allows me to change current user password.

    2. After changing password, set the same in wp-config.php file.

    Is it sufficient? Will it work or there are some other places which I should also change like MySQL, etc?

    Thanks in advance for any kind of help.

Viewing 6 replies - 1 through 6 (of 6 total)

  • That should work fine.

    To my knowledge.. the db password is only used in the wp-config.php file.

    It sounds like you have it right!

    Thread Starter Anonymous User 9948090

    (@anonymized-9948090)

    ^^ Thanks for your reply. Should I change the db password using cPanel -> Databases option or is there any other known way? Can we change it using phpMyAdmin?

    I’d change it in CPanel… in your DB manager.

    Are you unable to access the CPanel?

    Thread Starter Anonymous User 9948090

    (@anonymized-9948090)

    ^^ Thanks. It worked. I changed the password from cPanel, then checked the blog and it showed error connecting to database. Then I replaced the password in wp-config.php file with new one and blog started working again. ??

    Perfect. You performed the steps concisely, and accurately. And even knew how to “test”… impressive!! ??

    Thread Starter Anonymous User 9948090

    (@anonymized-9948090)

    ^^ Thanks. ??

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Changing MySQL Database Password’ is closed to new replies.