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_HISTFILEvariable 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_historyas a symbolic link to/dev/null:shell>
ln -s /dev/null $HOME/.mysql_historyYou need do this only once.