mysql在java中查询_在mysql中记录所有查询

OS / mysql版本：

$ uname -a

Darwin Raphaels-MacBook-Pro.local 15.6.0 Darwin Kernel Version 15.6.0: Thu Jun 21 20:07:40 PDT 2018; root:xnu-3248.73.11~1/RELEASE_X86_64 x86_64

$ mysql --version

/usr/local/mysql/bin/mysql Ver 14.14 Distrib 5.6.23, for osx10.8 (x86_64) using EditLine wrapper

添加日志记录(例如，我不认为 /var/log/... 是Mac OS上的最佳路径但是有效：

sudo vi ./usr/local/mysql-5.6.23-osx10.8-x86_64/my.cnf

[mysqld]

general_log = on

general_log_file=/var/log/mysql/mysqld_general.log

重启了Mysql

结果：

$ sudo tail -f /var/log/mysql/mysqld_general.log

181210 9:41:04 21 Connect root@localhost on employees

21 Query /* mysql-connector-java-5.1.47 ( Revision: fe1903b1ecb4a96a917f7ed3190d80c049b1de29 ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout

21 Query SET NAMES latin1

21 Query SET character_set_results = NULL

21 Query SET autocommit=1

21 Query SELECT USER()

21 Query SELECT USER()

181210 9:41:10 21 Query show tables

181210 9:41:25 21 Query select count(*) from current_dept_emp