Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a text based mysql UI?

I don't mean the standard mysql-client CLI, but 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

like image 874
Matteo Riva Avatar asked Jan 30 '10 15:01

Matteo Riva


People also ask

Is there a GUI for MySQL?

Database GUIs have been created in order to make it easy to manage MySQL databases visually, without having to manually type SQL commands. GUIs make the processes of designing, creating, and administering databases easier and more convenient.

What is the difference between MySQL and MySQL Workbench?

SQL is primarily used to query and operate database systems. MySQL allows you to handle, store, modify and delete data and store data in an organized way. SQL does not support any connector. MySQL comes with an in-built tool known as MySQL Workbench that facilitates creating, designing, and building databases.

How do I access MySQL GUI?

If you are looking for free MySQL GUI tool for basic database development, you can try PHPMyAdmin, HeidiSQL, or Workbench Community Edition. If you need advanced features, go for Toad Edge, dbForge. Hopefully, the above 5 MySQL GUI tools will help you manage MySQL databases.

What IDE is used for MySQL?

MySQL Workbench This is a unified visual tool for anyone who works with MySQL databases. With this IDE, you can visually design, model, generate, and manage databases. MySQL Workbench is available on Windows, Linux, and Mac OS X.


2 Answers

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.

like image 111
Jackson Miller Avatar answered Oct 17 '22 22:10

Jackson Miller


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.

like image 37
Vlad Balmos Avatar answered Oct 17 '22 22:10

Vlad Balmos