Connecting To Mysql From Application

[krishsathish]

I am sure this is probably a MySQL forum topic. But thought of posting here as SQLYog already seems to employ what I am looking for.

I have a need to build an application which works on top of MySQL. The application will be written in C/C++ (I am still learning that). Assuming that the application may or may NOT be installed in the machine where MySQL Server is running (which means the application needs to communicate with the server over the network), what options do I have to connect to the database from my application code.

I found in your documentation that you use C/C++ and connect to the server using MySQL C APIs. Does this mean that the MySQL APIs remain bundled along with your application ? If YES, can I bundle the same APIs with my application (without any licensing restrictions) too to connect to the server ?

Would appreciate any help.

BTW, I liked your tool !

[peterlaursen]

Quote:

can I bundle the same APIs with my application

Yes you can. The C API is included with the source distribution of the MySQL server.

About licensing read for instance:

http://www.mysql.com/news-and-events/newsl…0000000220.html. The GNU public license is not “without any restrictions”. But no restriction that prevents you to use it!

Quote:

what options do I have to connect to the database from my application code.

The API sends hostname, username, password, port (and database(s) if you choose). That is what you need to connect. The rest is server configuration. However if you need tunnelling you will need specific code for that.

The complet set of connectors and the MySQL source can be found here: http://dev.mysql.com/downloads/

[krishsathish]

Thanks for the help !

[Author]

Posts