Install MySQL connector/C++ on Ubuntu 11.04

Here is what I did to install MySQL and connector/C++.
First install MySQL Server.

Then download MySQL connector/C++ from here.
I used the binary file.



Extract the file and rename the folder, say, mysql.
Copy mysql/include/* to /usr/include/
Copy mysql/lib/* to /usr/lib/

When I build a cpp file using the following command:
    $g++ -Wall test.cpp -o t

the following error was issued:
    sql01.cpp:(.text+0x44): undefined reference to `get_driver_instance'
collect2: ld returned 1 exit status

After google for a while, I found I need to link libmysqlcppconn.so in the command like this:

    $g++ -Wall test.cpp -lmysqlcppconn -o t
But this time, instead of an error, a warning was issued:

    warning: libstdc++.so.5, needed by /usr/lib/libmysqlcppconn.so, may conflict with libstdc++.so.6

Finally, I add /usr/lib/libstdc++.so.5 into the command and solved this problem.

    $g++ -Wall test.cpp -lmysqlcppconn /usr/lib/libstdc++.so.5 -o t