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.
i suggest using phpmyadmin
it’s definitely the best free tool out there and it works on every system with php+mysql
Here are few solutions -
Since you are already using sqlyog, I suggest you to use same on Linux as well.
Why not try MySQL GUI Tools? It's light, and does its job well.
RazorSQL for Linux / Unix.
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.
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
Source: Stackoverflow.com