9
I have been down the same route as I am in the process of converting over to Linux from Windows.
On Windows I wouldn't go past MySQL Front. It is brilliant, especially if you can find the older versions (the free ones). On Linux the choices are more limited. I too like the look of Knoda and installed it. What a marathon that was. It was my first install from source and didn't have any of the compiler files installed. It took me 12 hours to get the thing up and running.
In the end I was very dissappointed. While its screens look great and the feature list looks good, it fell down when it came to handling SQL queries (even the queries it built itself). While it was happy with a "SELECT * FROM x", as soon as you added a WHERE clause it would error and not execute. It was quickly erased from the system.
I have now loaded MySQL Administrator and have MySQL Query Builder ready to go. I haven't had time to play with them yet but they look infinitely better than Knoda. All I want is something on Linux that will do what MySQL Front does. I am hoping the two programs from the people at MySQL will be the way to go.
