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.
Step 3 : Add newly created user to the same database.
Step 4 : This step is very important. Give user privileges to Newly created User exactly like before.
Now update all configuration files which uses the above database with the new password.
Follow these topics Linux, Technology