[Alan Sawyer]

I think where it's confusing is that now MYSQL specifically says that if you sell software that requires the user to download and install mysql to use, then it requires a commercial license.

This is part of the licensing.

Typical examples of MySQL distribution include:

* Selling software that includes MySQL to customers who install the software on their own machines.

* Selling software that requires customers to install MySQL themselves on their own machines.

* Building a hardware system that includes MySQL and selling that hardware system to customers for installation at their own locations.

Specifically:

* If you include the MySQL server with an application that is not licensed under the GPL or GPL-compatible license, you need a commercial license for the MySQL server.

* If you develop and distribute a commercial application and as part of utilizing your application, the end-user must download a copy of MySQL; for each derivative work, you (or, in some cases, your end-user) need a commercial license for the MySQL server and/or MySQL client libraries.

* If you include one or more of the MySQL drivers in your non-GPL application (so that your application can run with MySQL), you need a commercial license for the driver(s) in question. The MySQL drivers currently include an ODBC driver, a JDBC driver and the C language library.

* GPL users have no direct legal relationship with MySQL AB. The commercial license, on the other hand, is MySQL AB's private license, and provides a direct legal relationship with MySQL AB.

The general consensus on one of the forums that I belong to is that is the software you sell doesn't require mysql but can use it, for example, it supports mysql, postgresql, etc, then a commercial license is not needed.

I'm just trying to understand how this works. I love mysql, so unless I'm forced to go somewhere else, I will be staying.

Like you said, there are thousands of users doing just what you said, so who knows.

Alan

BTW, the info is located atMYSQL Licensing

[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

[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]

Thanks for the information. I will try it out.

Alan

[Alan Sawyer]

I had purchased Enterprise version and I love it, but I am wanting to create a USB drive that I can carry around with me and in case I need to do something on my website, be able to run sqlyog. I see where the community version looks like it might work and that's great, but do we agree that the Enterprise version won't work?? I guess the licensing may not allow it if it's really by Client. I'm a one man company trying to do my best, so any help would be appreciated.

Alan

[Alan Sawyer]

I am wanting to sync data so I'm picking Data Synronization Wizard on Powertools. It works, but is it possible to save an .sql file that contains the changes that were made to the database. I have used other tools that create an .sql file that shows all the changes that are made to the db and it would help me to understand what changes took place.

Alan Sawyer

[Alan Sawyer]

I ended up copying my server db that was in mysql4 to my local server which has mysql5 and doing the sync from there. That worked well, but I was wondering if there was a way to see what data was changed??

For example, what fields were changed and with what data??

Thanks,

Alan Sawyer

[Alan Sawyer]

Thanks, I didn't know that.

I will try to uninstall 5 on my local windows computer and install 4 and then see how it works.

Thanks again,

Alan Sawyer

[Alan Sawyer]

Using 5.02.

I went back to try to make sure I wasn't seeing things, because I'm wanting to sync a remote db and a local one, but now I'm getting a

NULL definition mismatch for 'ckey' column in '`pycategory`' table

error message. I am running mysql 4.x on the remote server and mysql 5 on my local windows computer, but the structure sync wizard says there are no differences in the tables. I have 2 tables.

This may be something I'm doing, but I'm not sure.

I could send you both db's if that would make sense.

Thanks,

Alan Sawyer

[Author]

Posts