ansaurus

Question

Mysql on the command line (can't use all keyboard buttons)

Answer 1

+1 A:

According to this thread and mysql --version, mysql is compiled with editline instead of readline. From that thread:

I had to add create an .editrc file with the following lines to get ctrl-R and DELETE to work.

bind "\e[3~" ed-delete-next-char 
bind "^R" em-inc-search-prev

Although that didn't work for me.

Another suggestion from that thread did work:

$ sudo apt-get install rlwrap

Then add an alias in ~/.bashrc

alias mysql='rlwrap -a mysql'

This problem may be specific to Ubuntu 9.10

Dennis Williamson 2010-01-20 18:30:50

The last post on the thread worked for me! (accepted for the find) Reproducing the code used here:$ sudo apt-get install rlwrap$ alias mysql='rlwrap -a mysqlSo basically it seems you are wrapping another program around mysql to get back the vi-like bindings. From the other comments on the thread it seems like this is a bug with Karmic itself.

Hooked 2010-01-20 18:48:28

The rlwrap alias works for me also.

Dennis Williamson 2010-01-20 18:49:13

This solution seems to handle other terminal-like issues (it worked for Mathematica and MAPLE as well).

Hooked 2010-02-11 18:46:53

ansaurus

tags:

views:

answers:

Mysql on the command line (can't use all keyboard buttons)

related questions