I'm running OS 10.11.1 and I want to use vi as my editor while in mysql. I tried creating a ~/.inputrc with:
set editing-mode vi
set keymap vi-command
It did not work, so I tried a ~/.editrc with the same. That did not work so I tried a ~./bashrc file with the same, and with just "set -o vi". None worked. I still have emacs as my editor while in mysql. I'm running MySql 5.6.21.
OS X El Capitan (10.11.1)
It's usually EDITOR. Somewhere in whatever you're using for a bash login, it's usually:
export EDITOR=’vim’
See the MySQL mailing list for a discussion (and some problems) somebody was having.
FWIW and from the GUI, the Sequel Pro tool works quite well for managing MySQL databases.
Thx MrHoffman. I tried adding the export to ~/.bash_profile but it still didn't make a diff.
Adding 'bind -v' (without the quotes) to ~/.editrc did the trick.
$> cat ~/.editrc
bind -v
How do I set vi key binding for mysql
