Quick and useful tip for large result sets in MySQL  (for example more than 100 MySQL db)

mysql> pager less;

mysql> show databases;

 

link : MySQL pager