If you forget the Mysql server password, you can reset it, using the below steps:
1. Stop the MySQL server (but not "Plesk SQL Server") from running on port 3306 using the Plesk Services Monitor tray utility or from services.
2. Edit the MySQL configuration file, %plesk_dir%\Databases\MySQL\Data\my.ini (or your installation path), and add the line skip-grant-tables to the [mysqld] section.
3. Start the MySQL server.
4. Log into MySQL without the password:
"%plesk_dir%\Databases\MySQL51\bin\mysql.exe"
To change the password for the MySQL administrator run the below 2 commands in the MySQL console:
UPDATE mysql.user SET Password = password('newpassword') WHERE User = 'admin';
flush privileges;
5. Remove skip-grant-tables from the MySQL configuration file and restart the service.
6. Log into the Plesk interface, go to the database server management settings (Tools & Settings > Database Servers), and change the password for the corresponding database server to the one set in Step 4, Plesk will re-establish the connection to the server.
Regards,
Yusuf M
1. Stop the MySQL server (but not "Plesk SQL Server") from running on port 3306 using the Plesk Services Monitor tray utility or from services.
2. Edit the MySQL configuration file, %plesk_dir%\Databases\MySQL\Data\my.ini (or your installation path), and add the line skip-grant-tables to the [mysqld] section.
3. Start the MySQL server.
4. Log into MySQL without the password:
"%plesk_dir%\Databases\MySQL51\bin\mysql.exe"
To change the password for the MySQL administrator run the below 2 commands in the MySQL console:
UPDATE mysql.user SET Password = password('newpassword') WHERE User = 'admin';
flush privileges;
5. Remove skip-grant-tables from the MySQL configuration file and restart the service.
6. Log into the Plesk interface, go to the database server management settings (Tools & Settings > Database Servers), and change the password for the corresponding database server to the one set in Step 4, Plesk will re-establish the connection to the server.
Regards,
Yusuf M
Comment