Setting up Mysql++ in linux

Question

I want to connect to a mysql database with C++ in linux. On my local machine I am running Ubuntu, and installed the mysql server and client packages: sudo apt-get install mysql-server mysql-client I came across Mysql++ but have some problems when running ./configure from their binary package. The error says: checking for MySQL library directory... configure: error: Didn't find mysqlclient library in '/usr/lib64 /usr/lib /usr/lib64/mysql /usr/lib/mysql /usr/local/lib64 /usr/local/lib /usr/local/lib/mysql /usr/local/mysql/lib /usr/local/mysql/lib/mysql /usr/mysql/lib/mysql /opt/mysql/lib /opt/mysql/lib/mysql /sw/lib /sw/lib/mysql' I see where I can use this command to specify the path: ./configure --with-mysql-lib=/... but I do not know where to point it to. I used whereis mysql but cannot find any mysql directory that contains a lib subdirectory. Where would the mysqlclient libraries be installed? EDIT: After doing locate `libmysqlclient` I got back /usr/lib/i386-linux-gnu/libmysqlclie…

Accepted Answer

this problem is caused because `size_t` depends on the inclusion of stddef namespace before it is called in the configuration (make) files. i had the very same problem (using an amazon EC2 ubuntu 12.04 cloud server) and solved it by editing the offending file (`sql_buffer.cpp` located, in my case, /home/ubuntu/mysql++-3.1.0/lib) and including stddef (while also moving string namespace up): ``` #include #include #include "sql_buffer.h" ``` your question is answered with this correction. BUT, you might have additional problems, like i did. so i explain how i solved some subsequent problems, which you might or might not have also. you might have to use ``` sudo chown username sql_buffer.cpp ``` to be able to edit the file, depending on how your install is setup (i am user ubuntu, for example). i then bumped into another problem: ``` ./ssx/genv2.cpp: In function âbool generate_ssqls2(const char*, const ParseV2*)â: ./ssx/genv2.cpp:70:28: error: âstrcmpâ was not declared in this scope ``` so i edited the offending file (`genv2.cpp`) and included string namespace ``` #include ``` then i had ANOTHER problem with: ``` ./libmysqlpp_ssqls2parse.a(ssqls2parse_parsev2.o): In function `Type': /home/ubuntu/mysql++-3.1.0/./ssx/parsev2.cpp:256: undefined reference to `mysqlpp::internal::str_to_lwr ``` i could have edited `Makefile.in` but chose to simply run in command line: ``` sudo g++ -o test_ssqls2 test_ssqls2_ssqls2.o -lmysqlpp_ssqls2parse -L. -lmysqlclient -L/usr/lib/x86_64-linux-gnu -lmysqlpp ``` i then continued the `make` process. that worked for me: mysql++ installed and running.

Setting up Mysql++ in linux

Solution

Problem