In order to reset your MySQL Password on Plesk Panel Kindly Follow the following steps:
- 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
WebSouls Team