SQL command to display query history

Question

I would like to show my executed sql command history in my MYSQL query browser. What is a sql statement to display history?

Answer 1

to try

cat ~/.mysql_history 

this will show you all the mysql commands running on the system

Answer 2

For MySQL> 5.1.11 or MariaDB

1. SET GLOBAL log_output = 'TABLE';
2. SET GLOBAL general_log = 'ON';
3. Look at the mysql.general_log table

If you want to output to the log file:

1. SET GLOBAL log_output = "FILE";
2. SET GLOBAL general_log_file = "/path/to/your/logfile.log"
3. SET GLOBAL general_log = 'ON';

As mentioned in jeffmjack's comments, these settings will be forgotten until the next session if you do not edit the configuration files (for example, edit /etc/mysql/my.cnf and then restart to apply the changes).

Now, if you want, you can tail -f /var/log/mysql/mysql.log

More information here: Server system variables

Answer 3

(Linux) Open terminal ctrl+alt+t run the command

  cat ~/.mysql_history 

you will get all previous mysql query history, enjoy :)

Answer 4

You will find him there

 ~/.mysql_history 

You will make it readable (without shoots) as follows:

 sed "s/\\\040/ /g" < .mysql_history 

Answer 5

Take a look ~/.myslgui/query-browser/history.xml here you can find the latest queries made with mysql_query_browser (several days)

Answer 6

You can look at the query cache: http://www.databasejournal.com/features/mysql/article.php/3110171/MySQLs-Query-Cache.htm , but it may not give you access to current queries and will be very successful -and -miss if it works (subtle pun)

But the MySQL Query Browser most likely maintains its own list of queries that it launches, outside of the MySQL engine. You will need to do the same in your application.

Edit: see dan m comment leading to the following: How to show the latest queries made in MySQL? looks great.