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 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.
MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.
MySQL is also cross-platform; and, like with Linux, there is no built-in GUI tool for Windows.
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
Here are few solutions -
Since you are already using sqlyog, I suggest you to use same on Linux as well.
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