StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POC++: Talk to and receive data from MySQL Server
text
Body
copied!<p>Either this this question isn't asked often (possible), everyone knows how to do it (doubtful), or I don't know how to search for it (likely).</p> <p>I want to get my C++ program talking to my MySQL server and able to run commands on it. I know MySQL has connector code available, but 1) it seems like much more than I need and 2) I just cannot seem to get it to work anyway.</p> <p>I want to be able to test the program on my computer, so remote access would be necessary. I do have SSH for the server.</p> <p>My final deployment will be able to run on the server itself.</p> <p>Executing and receiving/parsing output from MySQL databases is quite easy to do by hand. I can't however, figure out which way to go to get my program to do this.</p> <p>I figure I should be able to: 1. ssh into the web server (with password) 2. access the MySQL database 3. execute statements and retrieve their output</p> <p>I've read a lot about fork() and popen(), but due to their read-only or write-only limitations (unless I misunderstand), I just don't know where to go. Obviously I'd just take out the SSH step when the time comes to deploy it on the server. Can somebody give me some direction on this, or is this just not possible (doubtful).</p> <p>It is our own dedicated server so we have full reign with ssh and WHM, but I'd rather minimize the "intrusion" since I don't know enough about all the software on there if I broke something. I just want to communicate [directly] with the MySQL database.</p> <p>Thanks so much! You guys are awesome!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload