How to get vi keybindings to work in mysql client?

mysql unix vim command-line readline
dan picture dan · Feb 7, 2010 · Viewed 7.2k times · Source

I have vi bindings working in my bash shell using set -o vi in my .bash_profile. But I can't seem to get them to work in the mysql command line client. I only get emacs style bindings. How do you do this?

I also put these lines in my .inputrc, but to with no effect:

set editing-mode vi
set keymap vi

Answer

John Weldon picture John Weldon · Feb 7, 2010

Quick google reveals this... don't know if it helps.

Copied here for convenience:

Add the following on OS X 10.5:

$ cat .editrc
bind -v

This will work for OS X 10.4 and other operating systems:

$ cat .inputrc
set editing-mode vi

Related questions

How do you run a single query through mysql from the command line?

I'm looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would imagine it would go something like: mysql -uroot -p -hslavedb.mydomain.com mydb_production "select * from users;"

Read More
centos: Another MySQL daemon already running with the same unix socket

I have a strange error when starting mysqld service: Another MySQL daemon already running with the same unix socket. I've tried to list running services and stopping them but the same error happens when starting mysqld service. I can try …

Read More
How to run mysql command on bash?

The following code works on the command line mysql --user='myusername' --password='mypassword' --database='mydatabase' --execute='DROP DATABASE myusername; CREATE DATABASE mydatabase;' However, it doesnt work on bash file on excecution #!/bin/bash user=myusername password=mypassword database=mydatabase …

Read More