SQL command to display history of queries

try

 cat ~/.mysql_history

this will show you all mysql commands ran on the system

For MySQL > 5.1.11 or MariaDB

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

If you want to output to a 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 by jeffmjack in comments, these settings will be forgetting before next session unless you edit the configuration files (e.g. edit /etc/mysql/my.cnf, then restart to apply changes).

Now, if you'd like you can tail -f /var/log/mysql/mysql.log

More info here: Server System Variables

You 'll find it there

~/.mysql_history

You 'll make it readable (without the escapes) like this:

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