Hello guys. Im using MySQL 5.7.6 for testing some new features, including syslog support for client. Its working great and Im getting the following lines when using localhost:
Mar 12 12:36:34 server1 MysqlClient[17854]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql', QUERY:'use mysql' Mar 12 12:36:36 server1 MysqlClient[17854]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:5, DB_SERVER:'--', DB:'mysql', QUERY:'show tables;' Mar 12 12:36:55 server1 MysqlClient[17856]: SYSTEM_USER:'user1', MYSQL_USER:'userdb', CONNECTION_ID:6, DB_SERVER:'--', DB:'mysql', QUERY:'use mysql ' However, if I try to access MySQL in any other server, for example "mysql -uuser -ppasswd -hserver2", it doesn't log in syslog. My client section config is: [client] #password = [your_password] port = 3306 socket = /var/lib/mysql/mysql.sock syslog Have any of you tried this? Thank you in advance. Stephan