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
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.
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.
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.
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.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With