how to distribut MySQL-based C++ applications?

Question

0.00/5 (No votes)

See more:

At least I managed to write a code using MySQL C++ Connector and it worked :-) Now I'm going to run it on another machine and I don't know how. Do I need to install the whole MySQL server on that target machine? Do I need to beg the user to do that? :-D

Posted 9-Nov-11 18:38pm

Joseph Marzbani

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Accepted Answer · 2011-11-09T19:29:00

Solution 2

You do not need to install a new MySQL server. You only need the DLL that for MySQL C++ Connector.
In your connection string, you den specify the IP address or host name where the MySQL server is running.
Remember to have the right username and password.

Posted 9-Nov-11 19:29pm

Kim Togo

Comments

Joseph Marzbani 10-Nov-11 2:00am

That 's the exact point. Where should I have that MySQL server? On the target machine, right? If this is the case then the user should do some configuration, right again?

Kim Togo 10-Nov-11 2:07am

Where the MySQL is installed is up to you.
If you have 4 computers, then 1 computer can have the MySQL server installed and the other 3 computers can access the computer where the MySQL server is running.

All users are accessing the same MySQL server.

Joseph Marzbani 10-Nov-11 2:17am

Let's be more clear. I have a MySQL database and an application using it. Now I want to run that application on other machines without MySQL server running on them. What files should I ship along with the applications itself?

Kim Togo 10-Nov-11 2:27am

On the other computer, copy your program .exe file and mysqlcppconn.dll file or if you have compiled it with a static .lib file "mysqlcppconn-static.lib" you only need the .exe file.

when you create a MySQL_Connection object, you then specify IP address where the MySQL server is running, a valid username and password.

Example:
sqlConnection = new MySQL_Connection("192.168.1.100", "myusername", "mypassword");

Joseph Marzbani 10-Nov-11 2:48am

do you mean the user will need a connection to the Internet or something? :-(

Kim Togo 10-Nov-11 2:54am

No. You have to understand the basic in LAN network and IP protocol.
If you have 4 computers, and they are all on the same local area network (LAN). Then they probably have an IP address.
On the computer here the MySQL server is installed, write down the IP address (To see the IP address, rund CMD.EXE and type "IPCONFIG")

If the MySQL server has IP address "192.168.1.100", then use this IP address on the "new MySQL_Connection" options.

Joseph Marzbani 10-Nov-11 2:58am

Sorry but I mentioned that it's going to be a single user application. ONE application with ONE database for ONE user with a computer not connected to any network. I know I'm asking too much questions, but I really need it. Sorry Kim!

Kim Togo 10-Nov-11 3:10am

Okay then :-)
Then you need to install MySQL server, just has you self did. And for your own program, you have to copy the .exe file.

Joseph Marzbani 10-Nov-11 3:13am

Thank you master ;-)

Kim Togo 10-Nov-11 3:44am

You are welcome :-)

JackDingler 10-Nov-11 12:35pm

It's late in your development cycle and maybe you have good reasons to use MySQL, but you should know...

Microsoft SQL Express now ships standard with newer MS OS's and is available as a free download for older OS's. It can save you a lot of headaches in installing MySQL on every machine.