[QUESTION] What Database editor do you recommend for mac?

[Benji_kun]

Hi everyone,

I'm Benji an Admin and part time Developer on JutsuONLINE. I've been using Heidi SQL to make changes in our database but I also want to be able to make changes from my macbook. I tried using DbVisualizer and I can connect fine until I try to open the "Data" tab and I get this error;

An error occurred while performing the operation:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"jo_world"."item_template"' at line 1

If anyone could tell me what I'm doing wrong or recommend a better DB Editor I'd appreciate it greatly.

Thanks, Benji

[schlumpf]

Without posting the actual query, nobody will be able to help you.

[Benji_kun]

I actually figured out what I had done wrong now but I am having another issue that will undoubtably have a really simple answer making me feel quite stupid but here it goes anyway.

In Heidi SQL when you want to manipulate a value, you simply double click it and type in the new value, job done. However in DbVisualiser it doesn't seem to let me do this. I double click a field, I try typing in it when it's selected and I try right-clicking to see if there is an option to edit value but I really can't work it out.

Sorry for the noob question but any help would be appreciated or an alternative to DbVisualiser that I can use on mac.

[schlumpf]

Phpmyadmin fulfilled my complete GUI needs. Else, just use the command line and learn SQL.
I never had any other GUI and disliked most of those being suggested in guides. They tend to be horrible.

[iindigo]

I've always liked Sequel Pro, which is free, extremely stable, feature-rich, and has a native Cocoa UI (a real rarity for database software on OS X).

[Steff]

I simpe use phpMyAdmin for working with DB.
No system place or other requirements.
Only for making backups on the server I use HeidiSQL

Only importand is. USE A GOOD PASSWORD if you give access from outside and DONT name the folder phpmyadmin.

Also if you have a fixed IP adress you can set this in the outside admin user to restrict access. Dont change the normal admin. Create a new mySql user for this.

[Benji_kun]

I just downloaded Sequel Pro and I have to say it's exactly what I was looking for and very similar to what I have been using Heidi for so thank you iindigo.

I will definitely have a look at using phpmyadmin and learning some more SQL in the future, thank you for the advice Steff and schlumpf.