Reset the Plesk MySQL Password

Reset the Plesk MySQL Password

SSH [Mac | Windows] into the server as the 'root' user
Stop the MySQL process by running the command:

/etc/init.d/mysqld stop

Run the command:

    /usr/bin/ 'ls /usr/bin |grep mysql |grep safe' --skip-grant-tables

If the above command returns "No such file or directory," try the command:

        /usr/bin/safe_mysqld --skip-grant-tables

If that command returns "No such file or directory," try the command:

        /usr/bin/mysqld_safe --skip-grant-tables

Next, start MySQL:

    /etc/init.d/mysqld start

Log into MySQL with the command (you won't need to use a password or username due to the --skip-grant-tables command above):

mysql;

Change to the MySQL database:

    use mysql;

Update the 'admin' password (replace PLESK_PASSWORD with the correct password):

    update user set Password=password('PLESK_PASSWORD') where User='admin';

Flush any remaining privileges by running the command:

    flush privileges;

Exit the MySQL command prompt:

    quit

Now, restart the MySQL service by running:

    /etc/init.d/mysqld restart

Lastly, confirm the plesk password is listed in /etc/psa/.psa.shadow via the command:

    cat /etc/psa/.psa.shadow