search cancel

mysql probe available KPI shows Can't connect to local MySQL server through socket error


Article ID: 239438


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) DX Unified Infrastructure Management (Nimsoft / UIM) Unified Infrastructure Management for Mainframe CA Unified Infrastructure Management SaaS (Nimsoft / UIM)


We are able to connect mysql db in mysql probe but getting the error Can't connect to local MySQL server through socket.


- configuration


Release : 20.3

Component : UIM MYSQL

  • probe :mysql
  • version:1.51/1.70
  • mysql version : 5.6.19
  • robot version:9.33


It seems to be the sample connection that is generating that alarm, you don't need it, its just an example, so you can disable it or delete it and use your own and specify the host or IP address,

      username = sample_user
      password = 
      description = sample connection
      address = localhost
      retry_attempts = 3
      retry_delay = 5 sec
      port_number = 3306
      option = 2
      path = /var/lib/mysql/mysql.sock

From the mysql techdocs:

Verify if you can connect using the ipaddress instead of the hostname.

Make sure that mysqld is running. Update the MySQL client config.

Specify the path to the socket in a global or local option file and make sure that the path specified in the probe is updated.

See also: