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.
Follow these topics Linux, Technology
Short Link:
Loading tweets...
4 comments
Skip to comment form ↓
Luko Del Ponte
March 3, 2012 at 1:20 pm (UTC 5.5) Link to this comment
Hy,
do you have some experience with exporting and importing MySQL database?
Prasanna SP
March 3, 2012 at 1:42 pm (UTC 5.5) Link to this comment
Yes, I do.
Luko Del Ponte
March 5, 2012 at 12:23 am (UTC 5.5) Link to this comment
Great, just one question:
SQL or text format of export file? For exporting WP posts and pages to other WP database…
Prasanna SP
March 5, 2012 at 11:34 am (UTC 5.5) Link to this comment
.sql is is better for moving wp to another database. .sql.gz is even better if you have a Linux machine.