This is a small tip to find mysql commands history without login into mysql server.When we login into MySQL server,generally we uses up and down arrow key to find the history of MySQL commands.
Actually the MySQL commands history are saved in file called .mysql_history located in user’s home directory by which he/she logged into Linux System.
For eg. I login into MySQL server after using my system username called linuxworld and after this I log into mysql server,the MySQL history file will be saved in user’s home directory that is linuxworld home directory.
If you log into system with any particular user and then login into mysql server ,only mysql history will be saved in .mysql_history located in this particular user’s home directory.
linux@tuxworld:~$ ls -l .mysql_history -rw------- 1 linux linux 2448 Nov 15 20:57 .mysql_history linux@tuxworld:~$ ls -l ~/.mysql_history -rw------- 1 linux linux 2448 Nov 15 20:57 /home/linux/.mysql_history linux@tuxworld:~$ linux@tuxworld:~$ tail ~/.mysql_history select time(); select date(); SELECT CURDATE(); SELECT CURTIME(); use owncloud show databases; create database owncloud; use owncloud show tables; select * from oc_queuedtasks; linux@tuxworld:~$
Leave a Reply