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:
Alternatively, helpful explanations are also provided on the following link: 3 Best Ways to Change MySQL User Password By Examples
Comments
0 comments
Please sign in to leave a comment.