Support » Fixing WordPress » Changing MySQL Database Password

  • Resolved Yet Another WP User

    (@yet-another-wp-user)


    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)
  • Josh

    (@josh401)

    Moderator and Editor Customizer

    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!

    ^^ 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?

    Josh

    (@josh401)

    Moderator and Editor Customizer

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

    Are you unable to access the CPanel?

    ^^ 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. 🙂

    Josh

    (@josh401)

    Moderator and Editor Customizer

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

    ^^ Thanks. 😉

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