Search Mac Software Downloads
|
Deals: Daily  /  Discount Store  |  Weekly Popular  |  Hot Picks  |  iPhone  |  Mac OS X  |  AboutAdd a File +
DESCRIPTION
YourSQL is a client application that allows you to remotely connect to MySQL databases for management through a graphical interface.
Download Now
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.


SCREENSHOT

Developer:Ludit srl
Downloads:25,206
  - Version d/l:2,039
Internet:Internet Utilities
License:Free
Date:29 Jun 2008
Platform:PPC/Intel
RATING
****½
OTHER PEOPLE SUGGEST
Suggest something else:
YourSQL User Reviews (19 posts)Write A Review
sort: smiles | time
Oct 26 2008
*****

PAULNOJUSTPAUL  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. :-)  
(Version 1.8.0h)

praisebury
0
[ Reply ]
Jul 1 2008

INEX  Finally my favourite MySQL-DB Browser is back - and first try worked just fine! Thank you!  
(Version 1.8.0h)

praisebury
0
[ Reply ]
Nov 1 2007

CHRISTOPH3  No worky on Leopard.  
(Version 1.8.0e)

praisebury
0
[ 1 Reply - Reply ]
Replies:
Jun 29 2008

GRANTNEUFELD  The current version works with Leopard.  
(Version 1.8.0h)

praisebury
0

Jun 29 2005
*****

ANDRE  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.   
(Version 1.8.0e)

praisebury
0
[ 1 Reply - Reply ]
Replies:
Mar 1 2007

TGV  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.  
(Version 1.8.0e)

praisebury
0

Jun 28 2005
*****

JOHANNES F.  Works great.

Excel and CSV Support is great.

I would simply wish some

"Space"-Bars in the Toolbar.

Thanks  
(Version 1.8.0d)

praisebury
0
[ Reply ]
Apr 25 2005
****½

ANONYMOUS  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?  
(Version 1.7)

praisebury
0
[ 1 Reply - Reply ]
Replies:
Apr 25 2005

MORTENNORBY  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...  
(Version 1.7)

praisebury
0

Apr 9 2005

ANONYMOUS  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.  
(Version 1.7)

praisebury
0
[ 2 Replies - Reply ]
Replies:
Apr 9 2005

ALEX  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  
(Version 1.7)

praisebury
0
Apr 17 2005

ANONYMOUS  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.  
(Version 1.7)

praisebury
0

Nov 27 2004
***½.

ANONYMOUS  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.  
(Version 1.7b6)

praisebury
0
[ 1 Reply - Reply ]
Replies:
Dec 2 2004

ANONYMOUS  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.  
(Version 1.7b6)

praisebury
0

Oct 18 2004

SCOTT  New user having major problems.

Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream

** BEGIN NESTED EXCEPTION **

java.io.IOException

MESSAGE: Unexpected end of input stream

STACKTRACE:

java.io.IOException: Unexpected end of input stream

at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:387)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)

at com.mysql.jdbc.Connection.(Connection.java:491)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)

at YSServerSelector.run(YSServerSelector.java:92)

at java.lang.Thread.run(Thread.java:552)

** END NESTED EXCEPTION **  
(Version 1.7b6)

praisebury
0
[ 1 Reply - Reply ]
Replies:
Oct 19 2004

ANONYMOUS  Scott,

that seems to be a problem with the connection to the database.

Make sure the database is running on the machine you try to connect to, and that it accepts connections from your machine.

If you have any further problems, feel free to contact us at yoursql@magisterludi.com and we'll see if can do anything to get it working!  
(Version 1.7b6)

praisebury
0

Aug 13 2004

ANONYMOUS  No workie for me:

Server connection failure during transaction. Due to underlying exception: 'java.net.ConnectException: Connection refused'.

** BEGIN NESTED EXCEPTION **

java.net.ConnectException

MESSAGE: Connection refused

STACKTRACE:

java.net.ConnectException: Connection refused

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)

at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)

at java.net.Socket.connect(Socket.java:452)

at java.net.Socket.connect(Socket.java:402)

at java.net.Socket.(Socket.java:309)

at java.net.Socket.(Socket.java:124)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:121)

at com.mysql.jdbc.MysqlIO.(MysqlIO.java:220)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1884)

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.  
(Version 1.7b6)

praisebury
0
[ 1 Reply - Reply ]
Replies:
Aug 13 2004

ANONYMOUS  This is the standard message when attempting a connection to a non-existent server, or a server blocked by a firewall.  
(Version 1.7b6)

praisebury
0
View all 19 posts >>