MySQL Gui tool

Install PhpMyAdmin

I know a few people use MySQL Workbench http://www.mysql.com/products/workbench

PHPMyAdmin is a web based one

P.s build a Hackintosh or buy a Mac? :) You'll get everything you'll ever need then!

+1 for workbench. I'm using it on linux and it works like a charm.

Anyone tried HeidiSQL through Wine? Best tool really, but only supports Windows.

@bashy yup I intend to buy a Mac, but at work I'm stuck with a PC. Tried installing Niresh OS there, no luck, sadly.

I have used Heidi andWorkbench on Windows and I definitely prefer HeidiSQL. If it runs on Linux, try to use it.

PHPMyAdmin Is invaluable, didn't really find a gui tool that was faster, easier or more complete! Although it's web based it works damn well!

The other tool I use is Navicat which I mostly use to easy sync a remote database with a local one. Connects to my live server via an ssh tunnel so it's very easy to quickly peak on DBs on my production server and sync a local db with a remote one or vice versa. however i find its ui very bad so I use phpMyAdmin for everything else!

I do use PMA a lot but prefer working on Sequel Pro

Workbench works well for me. Better than PMA.

https://dl.dropboxusercontent.com/u/60672885/workbench.png

Right click on the table name and select rows and you get the listing, which can be edited! pretty much same as Sequel Pro

I dont know why but i never like mysql workbench.You can try Emma https://apps.ubuntu.com/cat/applications/emma/

A good php alternative to phpmyadmin is Adminer (http://www.adminer.org/). Just a single php script you can drop in (two files if you place an optional css theme file). I use it in my VM just in case I don't have a gui program handy.

Navicat http://www.navicat.com is really good, support multiple OS

There is also this Chrome plugin: https://chrome.google.com/webstore/detail/chrome-mysql-admin/ndgnpnpakfcdjmpgmcaknimfgcldechn

I use Sequel for basic things and Navicat for more complex stuff like SPs or something (which Sequel cannot handle until now as i know)

I guess navicat working over wine at linux so i prefer HeidiSql if im gonna use wine.

I highly recommend Navicat. http://www.navicat.com/products/navicat-for-mysql

HeidiSQL on Windows is pretty cool or SequelPro on mac is also awesome!

Navicat Essentials is available for Linux. Not free, but pretty cheap.

I use DBeaver with MariaDB

https://dbeaver.io/

Hi,

I recommend you to try dbForge Studio for MySQL. It's last version will definately fit for your request.

Regards)