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