Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

Use a MySQL-provided database management tool Apps
I was really glad to see that mysql.com is now offering the free MySQL Administrator for OS X. Although there are plenty of administrative utilities out there for MySQL, it's great to see one directly from the MySQL people themselves. Hopefully all Mac MySQL users will download this, and it will generate enough interest that the MySQL Query Browser will be ported over as well. Enjoy!

[robg adds: The Administrator is a really nice management package. I thought it would be a Java app, but based on my limited inspection of the package, I don't think it is -- I think it's Cocoa. It provides a very easy to use interface to all the various administrative aspects of managing a MySQL server. And I'm with the anonymous poster -- I hope the Query Browser is soon to follow, as it looks quite useful as well.]
    •    
  • Currently 3.60 / 5
  You rated: 3 / 5 (5 votes cast)
 
[10,089 views]  

Use a MySQL-provided database management tool | 21 comments | Create New Account
Click here to return to the 'Use a MySQL-provided database management tool' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Use a MySQL-provided database management tool
Authored by: webbix on Mar 22, '05 11:00:05AM

I found it and downloaded a week or so back and found it to work perfectly. Something had apparently broken on my other standalone apps, (java maybe?) and I could not connect to my database any longer.

I have only had limited use but the interface is very nice and it just works. Two thumbs up!



[ Reply to This | # ]
anyone else having a problem downloading?
Authored by: DaveJello on Mar 22, '05 11:13:09AM

Maybe I'm the only one, but I've been trying to download this for a while now and it fails every time. Safari and Firefox just spin away until the process times out. I first tried downloading it a week or two ago, and today when I saw this hint I thought maybe it had been fixed. No such luck yet...

Anyone else having this issue?



[ Reply to This | # ]
anyone else having a problem downloading?
Authored by: willjwade on Mar 22, '05 02:42:36PM
anyone else having a problem downloading?
Authored by: DaveJello on Mar 24, '05 11:16:20AM

just a whole lot of spinning...



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: lanej0 on Mar 22, '05 11:27:32AM

It's just a matter of time for the Query Browser. We've got a MySQL user group in my city, and a member of the MySQL team runs it. He said that they just had to find a Cocoa developer, now that they have one, we'll start seeing all of the major MySQL apps ported.



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: iolaire on Mar 22, '05 03:49:00PM

Also please note that the OCBC connector now comes in a OS X package - and it works!



[ Reply to This | # ]
localhost connection problem
Authored by: inchhigh on Mar 22, '05 05:18:31PM

I can't get this tool to connect to my local databases. It connects fine to remote database servers, but I can't connect using localhost or 127.0.0.1
it gives me a strange error. I know the user/pass are correct as I can connect from the command line or with cocoa mysql.

Has anyone else encountered this?

the error I get is:
"Connection Error
Could not connect to MySQL instance at localhost.
Error: You have an error in your SQL syntax near
'interactive_timeout=1000000' at line 1 (code 1064)"

If I change the user/pass to incorrect settings I get the error I would expect saying 'access denied for user ...etc' so I know it's not the user/pass



[ Reply to This | # ]
localhost connection problem
Authored by: Skurfer on Mar 23, '05 04:23:00PM

I think you might be having the opposite problem from me. I always connect to MySQL from my Mac using ssh to forward ports. When I told the MySQL Administrator tool to connect to "localhost", it tries to use the socket in /tmp no matter what, even though I'm not running MySQL locally, haven't asked it to use the socket, and I've specified a non-default port number.

I finally got it to connect (sort-of) by using "127.0.0.1" instead of "localhost", but it still seems to be confused about which machine it's talking to. For example, it says the server is stopped, and it looks for an error log based on my local hostname. Looks like the tool still needs some work.

Anyway, maybe you would have better luck connecting to "localhost", since you actually are running a local instance.



[ Reply to This | # ]
localhost connection problem
Authored by: carsten on Mar 28, '05 03:49:00PM

Same error here. :(

I used 127.0.0.1 not localhost, username and passwords are correct.

$ mysql --version
mysql Ver 11.18 Distrib 3.23.56, for apple-darwin6.6 (powerpc)



[ Reply to This | # ]
localhost connection problem
Authored by: kevin11 on Jun 11, '05 08:49:03PM

I have similar problems, but a different error msg:

Connection Error
Could not connect to MySQL instance at localhost.
Error: Unknown system variable 'sql_mode' (code 1193)

I don't even know where to begin to look for the solution to this and I know the username and pass are correct because I get a different error msg when I change them

Any Ideas???

---
K11



[ Reply to This | # ]
localhost connection problem
Authored by: kb5ql on Jun 16, '05 01:03:59PM

Check the version of MySQL you're running. I just realized I'm running version 3.23 (for legacy purposes) and the client shows as only compatible with MySQL 4.0 and up. This could be the cause of the problem. (I get the same error, too.)



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: merlyn on Mar 22, '05 05:28:17PM
Of course, for a real database, you'll want to wean yourself of MySQL and pop on over to PostgreSQL instead. See the PostgreSQL advantages for the positive reasons, and the MySQL gotchas list for the compelling reasons.

[ Reply to This | # ]
PostgreSQL instead of MySQL
Authored by: kadis on Mar 22, '05 06:13:17PM

While those may be compelling arguments, for most people, switching isn't an option. Most web hosts offer MySQL, not PostgreSQL, or if they offer PostgreSQL, it's for more money. Also most PHP (probably the most popular way to program a website) based applications are MySQL native, not PostgreSQL (and who wants to try to customize it?).



[ Reply to This | # ]
PostgreSQL instead of MySQL
Authored by: webgodjj on Mar 23, '05 12:22:42PM

I agree. I would like one day to use postgreSQL, however, it isn't as easy to learn. Go look at hotscripts.com and see how many tutorials there are writen, then look at the php scripts, and see how many use postgreSQL... not many... Though it is a great alternative and maybe better, this seems like a case of beta vs vhs.



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: ozzyrules on Mar 23, '05 08:59:53AM

Unless I am missing something, the documentation does not apply to the OS X version.

For example the ability to hold the control button (or any modifier) in the connection dialog to toggle the cancel button to skip does not work. No mention of this in the documentation at all.



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: ozzyrules on Mar 23, '05 09:02:25AM

I guess my real question is how do I start the MySQl server?



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: jonbauman on Mar 23, '05 10:51:52AM

If you installed MySQL from the provided OS X package, there should be a preference pane that can do it (though it sometimes indicates the server is running when it really isn't).

---
jon



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: carsten on Mar 28, '05 03:50:15PM
sudo safe_mysqld

[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: lolopb on Mar 23, '05 12:35:27PM

Great tool, thanks for the info.

Anyway, has some been able to save the password in the stored connection ? I tried many times, impossible. I don't even understand why they don't use the keychain for that. I used to use CocoaMySQL that did it, but, now I'd like to use this one as the interface is nicer.



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: tekjnke on Oct 27, '05 04:05:52AM

I am having a connect issue with mySQL and wonder if someone here can assist - if I am asking in the wrong area I apologize.

I am running MySQL 4.1.15-standard via socket on OSX 10.4.2, on a Mac Mini 1.5GHz with 1G ram, with a wired connection to the network. On the same machine, through mySQL QB I can connect just fine (go figure), but nothing else on the network can connect (which is a problem).

I am new to this so I am certain I missed something somewhere, but not sure what. The firewall is not on, there is no other security software in the way and we even directed the port 3306 to the machine for mySQL.

I suppose the biggest question is what is the server host we should enter? We've tried them all.

Thanks a ton!
-Tek
tekjnke@yahoo.com



[ Reply to This | # ]
Use a MySQL-provided database management tool
Authored by: zacamjo on Oct 28, '06 07:53:32AM

Hello all, I'm facing a similar problem though the circumstances are different.

I'm using an iMac (10.4.8) to connect to a remote server where the MySQL instance runs (a shared system with multiple domains on it). I can connect fine and do everything I need to do via phpMyAdmin but was hoping to instead use the MySQL Admin tool(s).

Attempting to connect using the server IP and one of the db users repeatedly fails, though the error seems ill-defined because it extends beyond the bottom of the connection window with no means of scrolling to read the whole thing (the error message cannot be highlighted, the window cannot be extended, and I can find no log of the event). What can be seen reads as follows:

<-- snip -->
Connection Error
Could not connect to MySQL instance at ###.###.###.###
Error: Host
'adsl-##-##-###-##.dsl.sgnwmi.sbcglobal.net' is not
<-- snip -->

That's all that can be seen. It sounds like my network provider (SBC/AT&T) has an issue with some aspect of the connection but I'm at a loss as how to proceed. Help?!



[ Reply to This | # ]