I’m a little chuffed with myself and just thought I’d share with somebody who might understand. I cracked the problem of how to get the results to display page by page with the ‘pager less’ command before running my select command so then the results are displayed page by page. The only issue now and perhaps you could shed some light on this is the when I run the following commands in MySQL on the metasploitable VM
select * from tables;
The results whilst shown page by page are very chaotic and not all lined up neatly as in the results of show databases for example. Would you happen to know why?