How to fix " Communications link failure" error thrown by MySQL server?

How to fix " Communications link failure" error thrown by MySQL server?

Error Message : Communications link failure

The last packet successfully received from the server was 16 milliseconds ago. The last packet sent successfully to the server was 16 milliseconds ago.


1. Ensure MySQL is running on the target server.

Windows

  1. net start | findstr MySQL

Linux

  1. systemctl status mysqld

2. Verify host and port configuration.
  1. SHOW VARIABLES LIKE 'port';
Ensure you are using this port while adding monitor

  1. SHOW VARIABLES LIKE 'bind_address';
Bind Address should be the Ip address of the Mysql Server


3. To Monitor MySQL server version greater than 5.6 and later download the latest driver and place under the below location and restart the Applications Manager
  1. AppMangager Home/working/mysql/MMMySQLDriver