Question
How to change a database user password in Plesk?
Answer
Changing a database user password via Plesk
-
Go to Domains > example.com > Databases > User Management > john_doe.
-
Specify a new password and click OK.
Changing a database user password via a command-line interface
-
Connect to the Plesk server via SSH (Linux) / RDP (Windows Server).
-
Use the 'plesk bin database' command to change the password (on Windows Server, use a command prompt as an Administartor).
In the example below, we are changing the password for the database user john_doe which is hosted on the local MySQL server:
# plesk bin database --update-dbuser john_doe -passwd "new_password_here" -server localhost:3306