How to search mysql command history

Question

The mysql command line client supports history (you can use the cursor keys to access and navigate it), but is there a way to search for a string, how can you do (for example) bash?

In bash you can:

history | grep "command" 

Is there something similar in mysql?

Answer 1

This usually lists all the MySQL commands used:

 less ~/.mysql_history 

Answer 2

You can use Ctrl + R to search for history, as in bash.

Answer 3

so in mysql you can use:

grep system "command" ~ / .mysql_history

Answer 4

Open the file in vim editor

vi ~/.mysql_history

then you can search for a pattern with / by entering text.