How to delete MySQL command line history
Introduction – On Unix or Linux system, the MySQL client writes a record of executed statements to a history file. By default, the history 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.
root@arunbagul:~# ls -l /root/.mysql_history
-rw——- 1 root root 71 2008-03-18 17:25 /root/.mysql_history
root@arunbagul:~#
root@arunbagul:~# cat /root/.mysql_history
show databases;
select * from databases;
show status;
show variables;
root@arunbagul:~#
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 -
ln -s /dev/null $HOME/.mysql_history
How to set Environment variable –
root@arunbagul:~# export MYSQL_HISTFILE=/dev/null
root@arunbagul:~#
** Please add about command in .bashrc file in your home directory so that this variable will be set to /dev/null value every time you lonin ..
root@arunbagul:~# cat /root/.bashrc
root@arunbagul:~#
Check the environment variable –
root@arunbagul:~# echo $MYSQL_HISTFILE
/dev/null
root@arunbagul:~#
NOTE- It’s not secure to save all executed mysql command to $HOME/.mysql_history file!!
Regards,
Arun Bagul
3 Replies to “How to delete MySQL command line history”
ohh, thanks I was not aware of this mysql features… Many times I thought about mysql command line history and where mysql is storing it. but never took action to find it out…
Thanks,
Nishit