13
Thank you for your review
Free
http://www.macupdate.com/download/10707/yoursql_1.8.0h.dmg
Email me when discounted: 
YourSQL is a client application that allows you to remotely connect to MySQL databases for management through a graphical interface.

What's New

Version 1.8.0h:
  • Now a Universal binary, working on both Intel and PPC. Requires OS X 10.4 or higher.
  • JDBC driver updated.

Requirements

Mac OS X 10.4 or later

Similar Software

Open Comparison
Suggest Other Similar Software
Leave a Review

YourSQL User Discussion

Nobody has reviewed or commented on this app yet. Add your own comment and get a discussion going!
Sort by: Time | Smiles
Negritude Member IconComment+1082
Negritude
+2

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

Reply0 replies
Version 1.8.0h
Grant Neufeld Member IconComment+5
Grant Neufeld
+0

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.

Reply0 replies
Version 1.8.0h
PaulNoJustPaul Member IconReview+100
PaulNoJustPaul
+0

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. :-)

Reply0 replies
Version 1.8.0h
Oliver Raduner Member IconComment+0
Oliver Raduner
+0

Finally my favourite MySQL-DB Browser is back - and first try worked just fine! Thank you!

Reply0 replies
Version 1.8.0h
christoph3 Member IconComment+11
christoph3
+0

No worky on Leopard.

Reply1 reply
Version 1.8.0e
GrantNeufeld
+0

The current version works with Leopard.

Anonymous Member IconReview
Anonymous
+0

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.

Reply1 reply
Version 1.8.0e
TGV
+0

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.

Anonymous Member IconReview
Anonymous
+0

Works great.
Excel and CSV Support is great.
I would simply wish some
"Space"-Bars in the Toolbar.

Thanks

Reply0 replies
Version 1.8.0d
Anonymous Member IconReview
Anonymous
+0

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?

Reply1 reply
Version 1.7
Ludit S.r.l. (Developer)
+0

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 yoursql@ludit.it with your ideas!

Re: b) Fix is on its way - should be there before Tiger itself...

Anonymous Member IconReview
Anonymous
+0

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.

Reply2 replies
Version 1.7
Anonymous Member Icon
Anonymous
+0

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

Anonymous Member Icon
Anonymous
+0

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.

Anonymous Member IconReview
Anonymous
+0

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: 'paddhcom@h000d9324e09b.ne.client2.attbi.com' (Using password: YES)"'.

** BEGIN NESTED EXCEPTION **

java.sql.SQLException
MESSAGE: Invalid authorization specification, message from server: "Access denied for user: 'paddhcom@h000d9324e09b.ne.client2.attbi.com' (Using password: YES)"

STACKTRACE:

java.sql.SQLException: Invalid authorization specification, message from server: "Access denied for user: 'paddhcom@h000d9324e09b.ne.client2.attbi.com' (Using password: YES)"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1977)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1900)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:950)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1887)
at com.mysql.jdbc.Connection.(Connection.java:440)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:400)
at YSServerSelector.run(YSServerSelector.java:193)
at java.lang.Thread.run(Thread.java:552)


** END NESTED EXCEPTION **


Attempted reconnect 3 times. Giving up.

Reply1 reply
Version 1.7b6
Anonymous Member Icon
Anonymous
+0

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.

There are no Ratings for this App yet.
> 5 13

Ratings

Overall
(13)
Current Version (1.x)
(13)

Details

Downloads 29,622
Version Downloads 6,441
License Free
Date 29 Jun 2008
Platform OS X / PPC 32 / Intel 32
Price Free
Learn how MacUpdate Desktop makes installing apps from MacUpdate.com one-click easy.
Next time, install YourSQL with 1-click

Learn how MacUpdate Desktop can install apps on MacUpdate with the simple click of the Install apps with MacUpdate Desktop icon. Plus, keep all your apps updated. Play video...