Is there a text based mysql UI?

I don't mean the standard mysql-client CLI, bu开发者_StackOverflow社区t rather something similar to what midnight commander is to filesystem management. The simple command history of the basic cli is not bad but really doesn't cut it when testing more complex query, and the layout of the data isn't that great. PHPMyAdmin is useful and all, but it's ugly and requires a lot of mouse usage.

OS: linux

dbext.vim provides DB access from within Vi. It provides things like stored connections, schema browsing, command history, some auto completion, and bind variables.

I assume there is something similar for Emacs.

I know this is an old question, but just in case neither of the above solutions have worked for you I would like to recommend Mitzasql - a simple text based Mysql client which gives you a quick read-only access to the database, data manipulation can be done through regular sql queries.

disclaimer - I am the author of said tool.

In emacs, there is a build in mode M-x sql-mysql.

You will be prompted for a user name, password, schema name (or database name), and the server name.

From then on, when one opens a .sql file, emacs should bind that .sql file to the SQL buffer associated with the MySQL session.

Inside that mode you can get help with a "Control-H m" keystroke.

There is a family of emacs sql- modes. They all pretty much work the same.