MySQL Client Config

20 Aug 2020

To give your MySQL a nicer prompt, and to disable autocommit, put this in $HOME/.my.cnf:

[mysql]
prompt=\\u@\\h:\\p/\\d>\\_
[client]
init-command='set autocommit=0'

To set up vim bindings, put this in $HOME/.inputrc:

set editing-mode vi

and, for good measure, put this in $HOME/.editrc:

bind -v