I use screen to manage my servers so I don't lose my place when my computer goes to sleep. It's great but it makes it hard to scroll back if you run a command that takes up more than a single screen. It's easy for normal command line items because you can run it through more or less but MySQL could be a problem.

There is a very simple fix in order to read all the results.

mysql> pager less
PAGER set to 'less'

Then to disable the pager setting.

mysql> nopager
PAGER set to stdout