mysql History File
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 , "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.