Introduction
If you are tired of MySQL throwing out a ~ every time you hit one of your navigation keys such as Home, End, and Delete, look no further.
Simple Solution
Recompile MySQL with --with-readline. The readline package is also required to run PHP in interactive mode (php -a).
