I’ve spent much time trying to solve that question. It took me nearly a year to solve it 🙂
There is nice option in mysql config called “pager”.
I’ve just published my configs for mysql client and grc (availiable in most nix dists). Check it out on github! https://github.com/nitso/colour-mysql-console