Hi all,
SSH 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
Thank you
