Can you recommend a free light-weight MySQL GUI for Linux?
MysqlLinuxUbuntuMysql Problem Overview
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 threads What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc…) and Developer tools to directly access databases
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.
Mysql Solutions
Solution 1 - Mysql
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 sudo apt-get install adminer
or you can also download the latest version from adminer.org
Solution 2 - Mysql
Here are few solutions -
- MySql Gui tools is official ui from Mysql.
- You can also try Mysql Workbench which is going to replace Gui Tools.
- Mysql Yog can be run on Linux using wine (I think they officially recommend this method).
- HeidiSql is also good option, I use it most of the time. It also run using wine on Linux. It lightest of all.
- If you are looking for web based solution than phpmyadmin is the solution.
Since you are already using sqlyog, I suggest you to use same on Linux as well.
Solution 3 - Mysql
Why not try MySQL GUI Tools? It's light, and does its job well.
Solution 4 - Mysql
I really like the MySQL collection of of GUI Tools. They aren't too large or resource hungry.
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.
Solution 5 - Mysql
http://www.razorsql.com/">RazorSQL</a> for Linux / Unix.
Solution 6 - Mysql
i suggest using phpmyadmin
it’s definitely the best free tool out there and it works on every system with php+mysql
Solution 7 - Mysql
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.