Learn how to change MySQL root password in the Plesk Control Panel. Our Plesk Support team is here to help you with your questions and concerns.

How to Change MySQL Root Password in Plesk Control Panel

Did you know that managing MySQL passwords in Plesk can be done via the Plesk Control Panel or the command line?

Here’s a step-by-step guide to help you through both methods.

Method 1: Using the Plesk Control Panel

Let’s take a look at how to change the MySQL password through the Plesk Control Panel:

1. First, access the Plesk control panel by logging in with your credentials.
2. Then, go to the “Databases” section within Plesk.
3. Now, locate and click on the specific subscription related to the database we want to manage.
4. After selecting the subscription, find and click on the “User Management” option to manage the users associated with the database.
5. Then, select the user for whom we want to change the password, typically the ‘admin’ user.
6. Now, enter a new password for the selected user as per our needs.
7. Next, confirm the changes by clicking “Ok” and then “Save” to apply the updated password successfully.

Method 2: Using the Command Line (for Linux)

We can also opt to update the MySQL password via SSH as seen here:

1. First, connect to the Plesk server via SSH.
2. Then, use the following command to update the MySQL admin password to the one specified in the `/etc/psa/.psa.shadow` file:

   mysqladmin -u admin -p[password from /etc/psa/.psa.shadow] password new_password_here

   Alternatively, we can use the `plesk bin database` command to change the password for a specific database user.

   For example, to change the password for the database user ‘bobcares’ hosted on the local MySQL server:

   plesk bin database --update-dbuser bobcares -passwd "new_password_here" -server localhost:3306

Our experts would like to point out that in Plesk, the default MySQL user is renamed ‘admin’ and has access only to localhost. On Plesk for Linux, the administrator’s password is encrypted in `/etc/psa/.psa.shadow`.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

In brief, our Support Experts demonstrated how to change MySQL root password in the Plesk Control Panel.