I am looking for a complete integrated mySQL management / admin tool (hopefully that can run in Linux). I need the ability to graphically model my tables and relationships (reverse/forward engineering would be great). I also need a tool with good data management options (i.e. basic crud).
I have tried MySql workbench and it is great for visually modeling my database (and can reverse and forward engineer very well). However, I found that it is lacking in good data management: i.e. inserting data etc is very awkward and not feature complete (text types do not seem to show up, datetime fields have to be entered manually instead of a calendar popping up etc.).
I briefly looked at the trial version of Navicat premium but their linux version seems to run under Wine which is not ideal. Any recommendations would be great! (Also free would be a plus - but not essential).