Best Way To Access Mysql Thru My Application

[Alan Sawyer]

Please excuse this question if it's not appropriate because it's a little off topic, but I use SQLYOG Enterprise and love it and am writing an application for a desktop that needs to issue sql statements to query, update, insert, delete data in my hosted mysql database and I'm trying to understand the best way to do this.

I can connect via sqlyog now and do the commands, but I believe it's not encrypted.

Should I try to use SSL or maybe SSH in my application to connect so it will be encrypted.

If so, does anyone know which one is probably easier to implement??

I'm using RealBasic to do this.

Is there a better solution that I just don't know?

Thanks for any help that anyone can give.

Alan Sawyer

[peterlaursen]

You are welcome to ask such question in our Forums. Hopefully some of our users will be bale to help you (I cannot because my knowledge about RealBasic == 'black hole' !!).

However SQLyog ENTERPRISE has both SSL and SLL options.

But you may tell how RealBasic connects to MySQL. Is there a 'wrapper class' for the C-API? Do you use ODBC? or how do you connect ??

[Alan Sawyer]

RealBasic has a plugin but it uses the MYSQL GPL client or something like that, so it supposedly can't be used since my application won't be GPL, so I will be using ODBC.

In this particular case, I'm not sure if my customer will have SSL has a possibility. They do have SSH, so if I can find an easy way to use SSH and my application that might be the best option.

Alan

[Alan Sawyer]

In a perfect world if I could find a command line SSH client for windows and eventually Mac, that would let me just shell off a ssh with the port, ip, username and password (maybe encrypted), and then have it connect and then I reference everything via localhost, that would be absolutely perfect, and I'm pay for it, well at least some reasonable amount for it.

And of course, I would want to make a one time payment for it, and not for each copy of my software.

Sure seems like there should be a good way to do this, but I just don't know what it is.

Or am I over reacting and it shouldn't matter if the data is encrypted?? It seems like with it not being encrypted, someone could steal the username password and then essentially be able to get into the db.

Alan

[Marjolein Katsma]

Alan Sawyer wrote on Sep 4 2007, 08:50 PM:

In a perfect world if I could find a command line SSH client for windows and eventually Mac, that would let me just shell off a ssh with the port, ip, username and password (maybe encrypted), and then have it connect and then I reference everything via localhost, that would be absolutely perfect, and I'm pay for it, well at least some reasonable amount for it.

And of course, I would want to make a one time payment for it, and not for each copy of my software

Have a look at Tunnelier – that at least has command line capabilities. Whether you can license it for such a use I don't know, but it couldn't hurt to ask 🙂

[Author]

Posts