How to create a shared object library (*.so) with mysql connector?

I have written a very simple application in C, for which I would like to have a connection with MySQL database. Here is the code:I have written a very simple application in C,