«

»

Print this Post

How to change MySQL user password in Cpanel

If you don’t have the Shell access to your server, then changing MySQL database user password within Cpanel would be a painful job. Because no option is given in Cpanel to change the MySQL user password. So you’ve to delete that user and add another user with the same name. Here I’m gonna show you how to delete the user and add that user again to the database.

Step 1 :  Delete the user that you want to change the password.

Step 2 : Add new User with the same name and enter new password. Then press Create User button.

Creating new MySQL user

Step 3 : Add newly created user to the same database.

Adding user to database

Step 4 : This step is very important. Give user privileges to Newly created User exactly like before.

Give user privileges to newly created user.

Now update all configuration files which uses the above database with the new password.

Short Link:

About the author

Prasanna SP

Student | WordPress Dev | Tech Blogger | Interested in GNU/Linux, FOSS, PHP, Drupal, WordPress, Ethical hacking, Photography, Painting, Literature etc..

Permanent link to this article: http://www.prasannasp.net/how-to-change-mysql-user-password-in-cpanel/

4 comments

Skip to comment form

  1. Luko Del Ponte

    Hy,
    do you have some experience with exporting and importing MySQL database?

    1. Prasanna SP

      Yes, I do.

      1. Luko Del Ponte

        Great, just one question:

        SQL or text format of export file? For exporting WP posts and pages to other WP database…

        1. Prasanna SP

          .sql is is better for moving wp to another database. .sql.gz is even better if you have a Linux machine.

Leave a Reply

Your email address will not be published. Required fields are marked *

Please put your code snippet between <code> and </code>. Comment moderation is in use. Please do not submit your comment twice -- it will appear shortly.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close