We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.
Closed 3 years ago.
开发者_JAVA百科 Improve this questionAnyone have any suggestions? Running Debian and looking for a good alternative.
There are a few different options that I know of, depending on the platform you are running it on. You could use the following:
- Linux: Dbeaver
- Windows: HeidiSQL
- Mac: SequelPro
MySQL Workbench is a great and cross platform tool. The UI might not look as slick as Sequel Pro but the features it provides are good enough.
I use phpmyadmin and find it adequate for most purposes, however I use greasemonkey to enhance various aspects. Here are a number of such scripts, you can of course write one on your own.
Another alternative is HeidiSQL. This is a Windows-only ® app but runs pretty well using Wine.
Then there is MySQL Workbench which has been mentioned in other posts. I don't find its query capabilities as fluid as phpmyadmin but generating ERD with it and synchronising with the database is pretty slick.
Yes! The last version of MySQL Workbench, in linux, is better than Sequel Pro.
With MySQL Workbench you can easily query, export data as csv and other formats, edit table data. It has a query guide inside. You can see the schema list, the table list, the columns for each table, the query box and the query result, everything at the same time.
I recommend TablePlus: tableplus.com
vStudio on linux or windows. I did have some problems with it crashing on linux but just updated to the latest version and it seems to run ok. It has a nice query editor and allows you to save your servers and projects. It is the best I have found so far.
Navicat is a paid client. I have only used it once but it fell short of expectations.
try sqlyog, awesome and the community edition is free.
phpMyAdmin is pretty simple and standard. Because it is web based, no installation required.
I recommend phpmyadmin or mysql workbench is best for any kind of DB GUI.
To setup phpmyadmin click here for complete guide.
To download mysql workbench you can simple go in ubuntu software and search mysql workbench and install it. You can click here to download complete offline installer for mysql workbench according to your OS. By terminal you have to follow these steps click here
im using SQLyog under wine
i think SQLyog have a good feature, not as much as mysql workbench but much faster
the paid version maybe even better
精彩评论