MySQL GUI tool is known for integrating SQL development, database design, administration, creation, and maintenance into single and useful development environment for database systems. Here is the list of some of the best MySQL GUI tools to choose the one that gives quality results.
Active2 years, 3 months ago
I'm setting up my first development Linux box - a netbook actually.I'm quite fond of MySQL Yog for Windows, but that's not on linux.
I've checked these two threadsWhat is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc…)and Developer tools to directly access databases
- Best free MySQL GUI Tool. Discussion in 'MySQL' started by weknowtheworld, Apr 19, 2007. Page 2 of 2 Best Answers: 0 Trophy Points: 36 #22. The closest thing I have used to a MySQL GUI is phpMyAdmin. It works really well and just requires PHP.
- Navicat for MySQL PremiumSoft Client is a GUI tool that allows you to perform integrated management and development MySQL database in an easier way. Advanced features allow you to create data models, data import / export, backup, transfer databases, create queries and manage your local or remote MySQL server.
- Finally, from H2LSoft comes MyDB Studio. It is a complete and free set of GUI tools for MySQL Server admin. It allows for easy create, edit, and drop database objects. In addition, you can also easily synchronize your database and import and export data with just mouse clicks.
- A few things have changed in the database landscape since our Top 10 MySQL GUI Tools list was compiled--in particular the emergence of cloud services. Keep that in mind when searching for the right MySQL admin tool.
- MySQL GUI tool is known for integrating SQL development, database design, administration, creation, and maintenance into single and useful development environment for database systems. Here is the list of some of the best MySQL GUI tools to choose the one that gives quality results.
I'm not interesting in something large and resource hungry (netbook) or that I have to pay for. Nor am I particularly interested in compatibility with SQL.
so, Can you recommend a free light-weight MySQL GUI for Linux?
Unless someone suggests something better I'll probably just go with phpMyAdmin.
Community♦
Dean RatherDean Rather18.9k1313 gold badges5656 silver badges6767 bronze badges
closed as off-topic by animuson♦Jul 23 '13 at 22:25
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.' – animuson
7 Answers
i suggest using phpmyadmin
it’s definitely the best free tool out there and it works on every system with php+mysql
knittlknittl161k3939 gold badges242242 silver badges290290 bronze badges
Try Adminer. The whole application is in one PHP file, which means that the deployment is as easy as it can get. It's more powerful than phpMyAdmin; it can edit views, procedures, triggers, etc.
Adminer is also a universal tool, it can connect to MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch and MongoDB.
You should definitely give it a try.
You can install on Ubuntu with
Ben McCannsudo apt-get install adminer
or you can also download the latest version from adminer.org10.6k1919 gold badges6464 silver badges8888 bronze badges
Tom PažourekTom Pažourek4,18455 gold badges4646 silver badges7979 bronze badges
Here are few solutions -
- MySql Gui tools is official uifrom Mysql.
- You can also try Mysql Workbenchwhich is going to replace Gui Tools.
- Mysql Yog can be run on Linux usingwine (I think they officiallyrecommend this method).
- HeidiSql is also good option, Iuse it most of the time. It also runusing wine on Linux. It lightest of all.
- If you are looking for web basedsolution than phpmyadmin is thesolution.
Since you are already using sqlyog, I suggest you to use same on Linux as well.
ShariqueSharique3,17166 gold badges3232 silver badges5151 bronze badges
Why not try MySQL GUI Tools? It's light, and does its job well.
Joshua PartogiJoshua Partogi11.9k1313 gold badges4646 silver badges7070 bronze badges
I really like the MySQL collection of of GUI Tools. They aren't too large or resource hungry.
![Mac Mac](/uploads/1/2/6/8/126879412/771099475.png)
There are quite a few options here as well. Of the applications presented on that page, I like SQL Buddy - it does require a web server, however.
Nick PrestaNick Presta24.9k55 gold badges4949 silver badges7373 bronze badges
kbosskboss
RazorSQL vote here too. It is not free, but it's not expensive ($70 for a perpetual license and 1 year of free upgrades).
If you use it for work, it will pay for itself quickly. I was jumping between MySQL GUI tools, SQL Server and Informix DBAccess, some of them through VMs because I use a Mac for development. Having a single tool to connect to any database out there is pretty nice. It is also highly customizable, and very reliable.
mjuarezmjuarez11.6k77 gold badges4040 silver badges5555 bronze badges
Not the answer you're looking for? Browse other questions tagged mysqllinuxubuntu or ask your own question.
Active6 years, 4 months ago
I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a chore.
I love that it runs in a web browser so that I'm able to run it on any host, but I've been moving from shared environments to dedicated hardware and have the ability to access MySQL remotely now.
Can anyone recommend the next level of MySQL administration once a developer has graduated from PMA? Is there an amazing GUI tool, or should I finally memorize those
CREATE TABLE
statements and use the command line?I've been a PMA user since 2004.
Thomas Hunter
Thomas HunterThomas HunterMysql Windows Gui
43811 gold badge77 silver badges1515 bronze badges
closed as not constructive by slhckApr 17 '13 at 14:52
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
4 Answers
I've been pretty happy with Sequel Pro. Free, expandable.
Gui Tool For Mysql
Doug HarrisDoug Harris21.3k1414 gold badges7070 silver badges104104 bronze badges
How about Navicat? Works on Mac and Windows. And on multiple types of databases (different products though). There is a free version in the app store to try
Canadian LukeCanadian Luke18.5k3333 gold badges9797 silver badges153153 bronze badges
Have you tried the MySQL Workbench? It's directly from MySQL themselves and quite good. The catch is you need to be able to directly connect to the database, so you might have to use an ssh forward if the database is locked down to local-only connections for security reasons (Whereas phpMyAdmin is accessible to anyone that the webserver permits).
![Gui Gui](/uploads/1/2/6/8/126879412/890038307.png)
It has GUI builders for creates, updates, alter tables, etc., and dare I say, makes working with MySQL tables almost as easy as using MS Excel, save for you having to click commit to save your changes.
Darth AndroidDarth Android34.7k44 gold badges7878 silver badges101101 bronze badges
I've used EMS SQL Manager several years ago. It is part of their SQL Studio, which has even more features. Both are rather expensive, Windows-only tools:
SQL Manager for MySQL allows you to create/edit all MySQL database objects, design MySQL databases visually, run SQL scripts, import and export MySQL database data, manage MySQL users and their privileges and has many other useful features for efficient MySQL administration.
Update: They apparently have a free 'lite' version, available for download, I cannot find what's the difference from the full version is.
haimgWhich Is Best Gui Tool For Mysql In Mac And Cheese
haimg17.5k1616 gold badges7272 silver badges112112 bronze badges