{"id":1097,"date":"2013-09-13T10:20:22","date_gmt":"2013-09-13T10:20:22","guid":{"rendered":"https:\/\/raspberry-projects.com\/pi\/?p=1097"},"modified":"2015-06-09T13:31:38","modified_gmt":"2015-06-09T13:31:38","slug":"setup-mysql-c-access","status":"publish","type":"post","link":"https:\/\/raspberry-projects.com\/pi\/programming-in-c\/databases-programming-in-c\/mysql\/setup-mysql-c-access","title":{"rendered":"Setup MySQL C Access"},"content":{"rendered":"

\nSome of this is based on the excellent guide here<\/a>.\n<\/p>\n

\nInstalling The MySQL C libraries
\n<\/h4>\n

\nMySQL comes with C-libraries:\n<\/p>\n

\r\n\r\nsudo apt-get update\r\nsudo apt-get upgrade\r\nsudo apt-get install libmysqlclient-dev\r\n<\/code><\/pre>\n
\nUsing In A Geany Project
\n<\/h4>\n
\nInclude the library in your source files\n<\/p>\n
\r\n\r\n#include <mysql\/mysql.h>\r\n<\/code><\/pre>\n
\nAdd these to the LIBS and CFLAGS sections of your makefile\n<\/p>\n
\r\n\r\n`mysql_config --libs`\r\n\r\n`mysql_config --cflags`<\/code><\/pre>\n
\nBeing Able To Compile Using NetBeans For Windows
\n<\/h4>\n
\nGo to: Project Properties > Build > Linker > Compilation Line > Additional Options > paste in this:
\n         `mysql_config –cflags` `mysql_config –libs`\n<\/p>\n
\nNote the single quote marks are correct and should be used as is!\n<\/p>\n
\nBeing Able To Compile Using Eclipse For Windows
\n<\/h4>\n
\nIf you are not coding on the RPi itself, for instance developing using eclipse for windows, you need to copy the mysql library files if your cross compiler toolchain doesn't have them.\n<\/p>\n
\nThe following is not based on any expert knowledge of ours, it is instead the results of our trial and error hitting it with a hammer until it worked…\n<\/p>\n
\n1 – Get the header files
\n<\/h5>\n
\nCopy this directory on the RPi:\n<\/p>\n
\r\n\r\n\/usr\/include\/mysql\r\n<\/code><\/pre>\n
\nto your projects directory.  Use this to include it in your C code file:\n<\/p>\n
\r\n\r\n#include "mysql\/mysql.h"\r\n<\/code><\/pre>\n
\n2 – Create Object Files
\n<\/h5>\n
\nCreate a file called main.c containing some code which uses the mysql library, e.g. this:\n<\/p>\n
\r\n\r\n#include <stdio.h>\r\n#include <string.h>\r\n#include <stdlib.h>\r\n\r\n#include <mysql.h>\r\n\r\nint main(int argc, char **argv)\r\n{\r\n\tMYSQL *mysql1;\r\n\tmysql1 = mysql_init(NULL);\r\n}\r\n<\/code><\/pre>\n
\nSave it in a directory on the RPI, then on the command line go to that directory and use this to compile it:\n<\/p>\n
\r\n\r\ng++ main.c `mysql_config --cflags` `mysql_config --libs`\r\n<\/code><\/pre>\n
\nNow use this to find out the directory used:\n<\/p>\n
\r\n\r\nmysql_config --libs\r\n\r\n<\/code><\/pre>\n
\nFor us it gives this:\n<\/p>\n
\n-L\/usr\/lib\/arm-linux-gnueabihf -lmysqlclient -lpthread -lz -lm -lrt -ldl\n<\/p>\n
\nSo, from directory:\n<\/p>\n
\n\/usr\/lib\/arm-linux-gnueabihf\n<\/p>\n
\ncopy the files\n<\/p>\n
\nlibmysqlclient.a
\nlibmysqlclient.so
\n(there's also files libmysqlclient_r.a and libmysqlclient_r.so in there but we've not bothered with them)\n<\/p>\n
\nPaste them into your windows machine folder:\n<\/p>\n
\nC:\\cygwin\\opt\\cross\\x-tools\\arm-unknown-linux-gnueabi\\arm-unknown-linux-gnueabi\\sysroot\\usr\\lib\\\n<\/p>\n
\nNow in eclipse, right click your project > Properties > C\/C++ Build > Settings > Cygwin C++ Linker > Libraries.  Add a new library entry:\n<\/p>\n
\nmysqlclient\n<\/p>\n
\nThis works but building the project fails because the library references other files which need to be added in also.  For us files listed in the eclipse build warnings we're all in this folder:\n<\/p>\n
\n\/lib\/arm-linux-gnueabihf\/\n<\/p>\n
\nBut if you need to search install and use mlocate to find them<\/a> on the RPi.\n<\/p>\n
\nFind each one and copy it into the same cygwin windows library folder.  These are the files we needed:\n<\/p>\n
\nld-linux.so.3
\nld-linux-armhf.so.3
\nlibmysqlclient.a
\nlibmysqlclient.so
\nlibz.so.1\n<\/p>\n
\nThat's it, for us this worked fine under rasbian and we could access our mysql database no problems.  I guess if the mysql library gets updated on the RPi then the files might need to be found and re-copied again so something to bear in mind if problems appear after updating the RPi ever.\n<\/p>\n
\n \n<\/p>\n
\n \n<\/p>\n
\n \n<\/p>\n
\n \n<\/p>\n
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Some of this is based on the excellent guide here. Installing The MySQL C libraries MySQL comes with C-libraries: sudo apt-get update sudo apt-get upgrade sudo apt-get install libmysqlclient-dev Using In A Geany Project Include the library in your source files #include <mysql\/mysql.h> Add these to the LIBS and CFLAGS sections of your makefile `mysql_config […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73],"tags":[],"class_list":["post-1097","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts\/1097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/comments?post=1097"}],"version-history":[{"count":22,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts\/1097\/revisions"}],"predecessor-version":[{"id":2026,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/posts\/1097\/revisions\/2026"}],"wp:attachment":[{"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/media?parent=1097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/categories?post=1097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/raspberry-projects.com\/pi\/wp-json\/wp\/v2\/tags?post=1097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}