Linux server clears MySQL's history and deletes mysql operation records _ MySQL

Linux server clears MySQL's history and deletes mysql operation records bitsCN.com

1. do not save historical records or reduce the number of historical records

Modify/etc/profile to change HISTSIZE = 1000 to 0 or the number of items to be retained
Clear. bash_history in the user's home path

Echo ''>/home/user/. bash_history

2. immediately clear the history of the history commands in it.

History-c

Of course, if you want to write the current command to history immediately, you can execute

History-w

Otherwise, it will only be written when bash is exited. Because these are stored in the current buffer during bash usage.

If you are a MySQL User, there will be a. mysql_history file in the user directory, saving the SQL statement executed in the mysql command line. Clear usage

Echo ''>/home/user/. mysql_history

BitsCN.com