Can’t connect to Plesk SQL Server (after updating Plesk admin password)
Default Plesk Database Provider Configuration
Jet engine is configured as the Plesk Database Provider by default, and therefore, the Plesk SQL (MySQL) service is set to disabled.
Password Setup During Installation
However, during installation, the Plesk installer sets the MySQL admin’s password to be the same as the Plesk admin’s password.
Issue After Changing Plesk Admin Password
As a result, if the Plesk admin password is later changed, the MySQL admin’s password remains unchanged—it still uses the one initially set by the installer.
Requirement for Switching to MySQL
Consequently, to switch the Plesk Database Provider to MySQL, it is necessary to either know the default Plesk admin’s password or, alternatively, reset the MySQL admin’s password so that it matches the current Plesk admin’s password.
Resolution
To switch Plesk Database Provider to Plesk SQL (MySql) server take the following steps:
1. Open “%plesk_dir%\MySQL\Data\my.ini” file in notepad;
2. Add “skip-grant-table” record in [PleskSQLServer] section;
3. Save the file;
4. Set startup type of Plesk SQL Server service to Automatic and start it;
5. To change the default MySQL admin password open command line prompt and run the following set of commands:
cd %plesk_dir%\mysql\bin
mysql -P8306
mysql> use mysql
mysql> update user set password=password(’<as your Plesk admin Password>’) where user=”admin”;
6. Remove “skip-grant-table” record which was added on step 2, save the file and restart Plesk SQL Server service;
7. Run Plesk Reconfigurator and select the Switch DB provider option;
8. Enter the administrator’s logins and passwords as following:
Server type: MySQL
Server adress: <enter the server address and port if required>
Administrator login: admin
Administrator password: <as your Plesk admin password>
Database: psa1 <or any name you like>
Database user name: admin1 <or any name you like>
Password: <as your Plesk admin password>
Confirm password: <as your Plesk admin password>
Source: http://kb.parallels.com/en/5532
Here is a related post you maybe interested in: MRTG Installation & Configuration/
