Forums

[resolved] Changing MySQL Database Password (7 posts)

  1. Yet Another WP User
    Member
    Posted 4 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.

  2. Josh (Ultimate Tinymce)
    Member
    Posted 4 months ago #

    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!

  3. Yet Another WP User
    Member
    Posted 4 months ago #

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

  4. Josh (Ultimate Tinymce)
    Member
    Posted 4 months ago #

    I'd change it in CPanel... in your DB manager.

    Are you unable to access the CPanel?

  5. Yet Another WP User
    Member
    Posted 4 months ago #

    ^^ 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. :)

  6. Josh (Ultimate Tinymce)
    Member
    Posted 4 months ago #

    Perfect. You performed the steps concisely, and accurately. And even knew how to "test"... impressive!! ;)

  7. Yet Another WP User
    Member
    Posted 4 months ago #

    ^^ Thanks. ;)

Reply

You must log in to post.

About this Topic