Plesk is not accessible: 500 PleskExceptionDatabase: Plesk SQL Server: Error 1053

Symptoms

• The Plesk UI is not accessible with the error:

  500 PleskExceptionDatabase

• It is not possible to start the Plesk SQL Server service with the error:

  Error 1053: The service did not respond to the start or control request in a timely fashion.

• The next error can be found in the Event Viewer or the MySQL log file:

  [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
  [ERROR] Do you already have another mysqld server running on port: 3306 ?
  [ERROR] Aborting

Cause

The Plesk SQL Server service is configured incorrectly: the Path to executable parameter in the Plesk SQL Server configuration does not contain the data about the configuration file.

Resolution

1. Connect to the server via RDP

2. Open the Command Prompt under Administrator.

3. Determine the path to Plesk directory:

   C:> SET | findstr plesk_dir

4. Use the plesk_dir from the output of the previous command to set the correct value for Path to executable parameter. E.g. if the output was as follows:

   C:> plesk_dir=C:Program Files (x86)Plesk

   , use the following command:

   C:> sc config PleskSQLServer binPath= ""C:Program Files (x86)PleskMySQLbinmysqld.exe" --defaults-file="C:Program Files (x86)PleskMySQLmy.ini" PleskSQLServer"