Home / server / Questions / 955976
Accepted
Tony
Asked: 2019-02-28 05:26:03 +0800 CST

How do I set MySQL CLI to use pager output by default?

  • 772

I found this wonderful output format for the MySQL CLI here. The command is mysql> pager less -SFX. I would like this to be my default and not have to enter the command every time I start the MySQL CLI. How can I go about setting this as a default?

mysql

1 Answers

  1. Best Answer

    The pager can be set from the mysql client commandline with the --pager= option.

    So one option is setting up an alias in your shell such that your custom pager is always set in your ~/.bashrc something similar to :

    alias mysql='mysql --pager="/usr/bin/less -SFX"'

    Alternatively any --option= commandline option can be set as option= in the relevant section of your personal ~/.my.cnf file. For instance: 

    [mysql]
pager="/usr/bin/less -SFX"
    • 6