Sample config files showing how to colorize linux console mysql client using grc
How to use it
- Install grc (for debian systems:
apt-get install grc)
- Copy both config files into your home directory
- Run mysql client
mysql -u <user> -p -h <hostname>
How does it work
Mysql client supports using predefined pager for data output.
So we can set grcat (Generic Colouriser) for processing mysql output.
grcat reads supplied config file, parses output according to regexp's and adds colours.
grc manual can be founded via
man grc or here: http://kassiopeia.juls.savba.sk/~garabik/software/grc/README.txt
Another one nice hack
You can also use
less in pager to have some features like scrolling, search, line numbers etc.
pager = grcat ~/.grcat | less -RSFXin
man less to read about less parameters.