How can I change the MySQL root password in Plesk?

Question

• How can I change the MySQL/MariaDB root password in Plesk?
• Can I change the MySQL/MariaDB root password in Plesk?
• Can I see the MySQL/MariaDB root password in Plesk?

Answer

The MySQL/MariaDB service that is created by Plesk on Linux does not have a root user, because Plesk uses admin user instead.

To reset the password for this user, please follow the steps in this article:

Note: The steps reset the password for the Plesk interface Admin user and regenerate the hash sum in /etc/psa/.psa.shadow, which is a password for the MySQL/MariaDB "admin" user.

How to get/reset lost Plesk Administrator password in Plesk for Linux

If you want to reset the passwords for any other MySQL/MariaDB users like root, mysql etc., you need to use MySQL/MariaDB native tools.

On a Plesk server, you may enter MySQL as the admin user by executing the following command:

# plesk db

Once you have entered MySQL/MariaDB, you may create users and alter MySQL user information by following the steps from the official documentation:

• MySQL 8.0 Reference Manual/Account Management Statements.

• MariaDB/User Account Management

Alternatively, helpful explanations are also provided on the following link: 3 Best Ways to Change MySQL User Password By Examples