The developer's web site is dead. You can still download the program from here:http://macfiles.brothersoft.com/internet/remote_access/YourSQL_1.8.0h.dmg
Sadly, this great little database tool will not work with Mac OS X 10.6 (Snow Leopard) or later.
The Cocoa-Java framework the application was build with has been discontinued by Apple and the developer has ceased work on YourSQL.
This is a really good, solid MySQL management app.
I've previously been a CocoaMySQL fan but miffed a little by its occasional instability.
I now use YourSQL daily at work to manage multiple dbs on multiple hosts. Nothing huge, but it easily and reliably does all I need. The column view of host -> db -> table is a really nice point of difference, too. You're never in any doubt over what db you're about to mess up. :-)
Finally my favourite MySQL-DB Browser is back - and first try worked just fine! Thank you!
No worky on Leopard.
The current version works with Leopard.
Really nice software. I tried almost every other app to manage SQL databases and i found this one to be the best, because it is frequently updated, never crashed and it is the nearest thing to MySQLControlCenter (which is not available for mac). I used this software to create my project at university and it did his job wuite well; i would justs like to see more options in the preferences menu and in the tables menu.
Well, here it crashes continuously. It doesn't show the design of several tables, gives very strange error messages on select queries (unknown fields with garbage names) and quits without any warning on changing databases.
Excel and CSV Support is great.
I would simply wish some
"Space"-Bars in the Toolbar.
Love this software. There are just two things:
a) A long-running frustration with blobs - I have some large text blobs that are hard to handle in the viewer. Is there any chance that in addition to an image blob viewer, there might also be a way to add a text viewer?
b) The main window doesn't seem to open in Tiger. Are there any fixes anyone can suggest?
Thanks for the feedback!
Re: a) Is it anything the full-page pane doesn't handle properly, or would you prefer it not to be in a sheet?
Feel free to contact us at firstname.lastname@example.org with your ideas!
Re: b) Fix is on its way - should be there before Tiger itself...
What I see here in the reviews are three different Java error messages.
And regardless if it's the fault of these users that the app could not connect, it's the job of the developer to display useful error messages. He doesn't even apologize that his application did not catch this exception and tell something useful, but states this are "default messages for this or that case".
If the developer isn't even able to implement the most simpliest exception handling, I wouldn't trust his application any of my data.
What? Look at the "message" part of the error.
"MESSAGE: Invalid authorization specification, message from server: "Access denied for user"
"MESSAGE: Unexpected end of input stream"
"MESSAGE: Connection refused"
The problems are pretty obvious even to me, and I have little/no MySQL experience.
YourSQL makes it easier to manage a MySQL database, however it's not a substitue for intelligence.
With that being said, I suppose he could add an error handler that explains what the error means, but there was no reason for you to attack him like that. The program is free, he has no obligation to do what you say. A comment/suggestion is fine, but an insult and a demand? Geeze...
Note that it's open source. If he doesn't feel something is necissary, and you do, you're free to put it in the code.
I'll even give you a link. http://www.mludi.net/YourSQL/download.php
Sorry if the error messages are not clear enough.
The original design of YourSQL was largely based on the official Connector/J driver's ability to handle error messages from the server, and YourSQL just took the error messages from the driver and showed them to the user.
This worked nicely, because the driver just took the messages from the server and passed them on.
With a recent change to the driver, this has changed, and error messages from the driver are now often page-long stack traces from the exceptions used to signal the error.
No need to mention that the driver of course handles all such exceptions nicely, it just prints the underlying stack trace along the way.
YourSQL has now been changed to personalise the error messages of the most common connection problems, and a few notes have been added to the help pages, explaining what the error could stem from.
Sorry again if these stack traces from the driver have caused confusion, but we are working on some better error messages.
Feel free to send an email if you have any further comments or questions.
I have always gotten the following error with every version of YourSQL that I've tried:
Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'email@example.com' (Using password: YES)"'.
** BEGIN NESTED EXCEPTION **
MESSAGE: Invalid authorization specification, message from server: "Access denied for user: 'firstname.lastname@example.org' (Using password: YES)"
java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'email@example.com' (Using password: YES)"
** END NESTED EXCEPTION **
Attempted reconnect 3 times. Giving up.
That is because, as the error message says, you do not have sufficient privileges to log in with the user id and password you use.
Make sure the necessary privileges have been set up on the server, and the login should work without problems.
Learn how MacUpdate Desktop can install apps on MacUpdate with the simple click of the icon. Plus, keep all your apps updated. Play video...
Discover New Mac Apps. Save money with MacUpdate Promo & keep your Mac software secure and up-to-date with MacUpdate Desktop.