[ellias2007]

Hi every body,

i downloaded MySql (Mac OsX Version) and also the nice program MySql Query Browser, i can connect to the Database "test" (already coming with MySql), but i face many problems :

1) when i right-click on the object browser and make "New Schema", write a name for this new shema, and click OK .... NOTHING happens and i can NOT see the New shema in the list in the object Browser! ... i right click again and choose Refresh many times ... Nothing appears !

2) after i try 2 or 3 times doing that, the software Quit unexp....

3) Is MySql Query Browser able to make a new Database and Design the relation ship between its tables also ??? i read ALL its Manual Guide, i found Nothing !

4) Finally, the mac version does Not contain all what the windows version does!

Many thanks...

[Gavin]

I've always found MySql Query Browser to be buggy.

try sequelpro - it doesn't attempt to be everything at once.
http://www.sequelpro.com/

[besson3c]

ellias: does the user you are connecting as have the permissions it needs to create databases? That's all I can think of... With no logging or any sort of indication what is actually going on under the hood, it's anybody's guess. If you really want a reliable client to replace the MySQL shell, phpMyAdmin is an option too.

[elmacgato]

I have just purchased a full featured MySQL App called navicat. It does cost some money but you can try it for free to see if you like it. I personally think it is the cat's pajamas.

http://mysql.navicat.com/

I do agree that "MySql Query Browser" is crap.

[besson3c]

I have doubts about how useful navicat or the like are for uses other than testing and development. General purpose hosts are not going to open up port 3306 for apps like this. This might be useful for local testing, for contacting a MySQL server on your LAN, but it is likely a no-go with most general purpose web hosts.

[Love Calm Quiet]

I'll second besson3c on phpmyadmin: http://www.phpmyadmin.net

Then you can just use Safari or Firefox for nearly everything you need to do with your MySQL DBs.

[besson3c]

I'll add that another way to get something like Navicat working is via a VPN connection, but again, I doubt that most hosts provide VPN access.

There are also security issues. SSL encryption is not enabled by default in MySQL, last I checked, so it is up to the client to encrypt their communication to the server via stunnel and its Windows equivalent. Again, no MySQL admin in their right mind would open up port 3306 to the general public, and if they did, I wouldn't recommend hosting sites with them anyway.

[mattyb]

Its not popular in the world of GUIs, but the best way to really learn the guts of a database management system is to use the command line. You can also be sure that you'll have access to it. You'll learn the commands that are most useful, and you'll learn the tables that are most useful to an administrator.

Just my opinion of course.

[besson3c]

I agree mattyb. The thing I like about phpMyAdmin though is that it doesn't obfuscate what it is actually doing. Whenever you run a command it outputs the query that it ran. I'm sure I understand what it is that is actually being done and use phpMyAdmin just to save me from some extra typing, but it is definitely very very wise to understand what the queries are that are being run. Even phpMyAdmin could have some sort of bug in some sort of version where it would run a bad query and taint all of your data, but if you can't understand what a particular bad query would do, hypothetically, and don't have a backup handy, you'd be in a world of hurt.

It is also useful to learn several data backup strategies, whether this means backing up the MySQL files themselves, learning mysqldump, learning how to manually copy tables, or concocting data refresh scripts...