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

Created:

2016-12-12 03:44:37 UTC

Modified:

2017-08-08 13:35:09 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

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.

Have more questions? Submit a request
Please sign in to leave a comment.