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:
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!