To clear the MySQL command line history stored in the ~/.mysql_history file, you can use the > operator to redirect an empty string to the file. This will overwrite the file with an empty string, effectively clearing the history.
Here's an example of how to use the > operator to clear the MySQL command line history:
echo "" > ~/.mysql_history
This will overwrite the ~/.mysql_history file with an empty string, effectively clearing the history.
Alternatively, you can use the truncate command to clear the file. For example:
truncate -s 0 ~/.mysql_history
This will truncate the ~/.mysql_history file to zero bytes, effectively clearing the history.
Keep in mind that these commands will only clear the MySQL command line history stored in the ~/.mysql_history file. If you want to clear the MySQL command line history for all users on the system, you will need to run these commands for each user's ~/.mysql_history file.