While we strongly recommend that you don't change the root cPanel MySQL password, there are certain circumstances in which this might be necessary. Please find below a step-by-step guide on how to accomplish this:
- Login to the SSH (Secure Shell) of your cPanel VPS Server
- Run the following command # cat /root/.my.cnf
- It should show you something that looks like this:
- Finally, you will need to be able to adjust the password, by doing the following:
mysql --user=root mysql
update user set Password=PASSWORD('new-password') where user='root';
That's it; you've successfully updated the cPanel MySQL root password for your cPanel Virtual Private Server. If you find that you have any issues with this, please feel free to contact with your cPanel web hosting support department for further assistance.