MySQL Server service is missing: No connection could be made because the target machine actively refused it

Symptoms

MySQL Server service is missing from Windows Services list.

Installation of Plesk micro-updates fails with message:

[ERROR]Unable to connect to database. System message: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

phpMyAdmin shows the following error:

The server is not responding (or the local server's socket is not correctly configured).

Websites that use MySQL databases does not work.

In Plesk > Tools & Settings > Database Servers , MySQL server is not connected.

Cause

Service was manually removed from Windows Services.

Resolution

1. Run Windows command line and register the service using the command below:

   "%plesk_dir%\\Databases\\MySQL51\\bin\\mysqld.exe" "--install MySQL" "--defaults-file=C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL\\data\\my.ini"
   

   Note: Path to MySQL configuration file may be different. It is located in %plesk_dir%\\Databases\\MySQL\\data\\my.ini , where %plesk_dir% is Plesk installation path.

2. Check in Plesk > Tools & Settings > Database Servers that server is connected.

Additional info

Plesk login fails: Unable to connect to database.