When running a data collection job for MySQL you receive the following error.
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Either that file does not exist (mysqld is not running), or has been moved to a different location than the default.
Make sure that mysqld is running. Update the MySQL client config.
Specify the path in a global or local option file. For example, put the following lines in /etc/my.cnf: