Menu
When using mysql through command line (with default shipped configuration), I was able to get my commands history using up-arrow.
Bu after modifying the server configuration for a remote access and successfully authenticated to, I'm not able to view any command and it feels annoying thinking that I lost all my commands history.
Is there some location where mysql stores previously used commands?
BR.
724
Get History of All MySQL Commands in a File Copy SET GLOBAL log_output = 'file'; SET GLOBAL general_log_file = "/yourPath/logfile. log"; SET GLOBAL general_log = 'on'; Now, locate the file at the specified path and open it to see all the details.
On Unix, mysql writes the statements to a history file. By default, this file is named . mysql_history in your home directory.
On Unix, the mysql client logs statements executed interactively to a history file. By default, this file is named .mysql_history in your home directory.
Please read out MySQL Documentation.
64
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
