1：打开通用日志
2：还存了一份在这里，今天才知道
[root@devdb1 ~]# cd /home/bzuo/
[root@devdb1 ~]# ls -al .mysql_history
-rw------- 1 root root 41536 Feb 28 23:12 .mysql_history
[root@devdb1 ~]# more .mysql_history
On Unix, the mysql client writes a record of executed statements to a history file. By default, this file is named
.mysql_history and is created in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment
variable.
The .mysql_history should be protected with a restrictive access mode because sensitive information might be written to it,
such as the text of SQL statements that contain passwords. See Section 5.3.2.2, “End-User Guidelines for Password Security”.
It is possible to suppress logging of statements to the history file by using the --batch or --execute option.
If you do not want to maintain a history file, first remove .mysql_history if it exists, and then use either of the following techniques:
• Set the MYSQL_HISTFILE variable to /dev/null. To cause this setting to take effect each time you log in, put the setting
in one of your shell's startup files.
• Create .mysql_history as a symbolic link to /dev/null:
shell> ln -s /dev/null $HOME/.mysql_history
You need do this only once.
阅读(2017) | 评论(1) | 转发(0) |
