Is there a mysql text interface?

Question

I do not mean the standard mysql client CLI, but rather something like the midnight commander refers to file system management. The simple command history of the base cli is not bad, but it doesn’t actually cut it when testing a more complex query, and the data layout is not so good. PHPMyAdmin is useful and all, but it is ugly and requires a lot of mouse use.

OS: linux

Answer 1

dbext.vim provides access to the database from within Vi. It provides features such as saved connections, viewing a schema, command history, some auto-completion, and variable binding.

I guess there is something similar for Emacs.

Answer 2

Emacs has a built-in Mx sql-mysql mode.

You will be prompted for your username, password, schema name (or database name) and server name.

From now on, when you open the .sql file, emacs should link this .sql file to the SQL buffer associated with the MySQL session.

Inside this mode, you can get help with the “Control-H m” key.

There is a family of emacs sqac modes. They all pretty much work the same way.

Answer 3

I know this is an old question, but in case none of the above solutions worked for you, I would recommend Mitzasql - a simple Mysql text client that gives you quick read-only access to the database, data manipulation can be done using regular SQL queries.

Disclaimer - I am the author of the specified tool.