I need to install a user defined MySQL function from C source code. The README file told me to compile with this command:
gcc -I/usr/local/include/mysql -O -pipe -o libgeocalc.so -shared -L/usr/local/lib/mysql -lmysqlclient mysqlgeocalc.cc
It gives me a lot of errors, probably because those are the wrong directories in the command line. What directories should I use? Will it even be possible to use user defined functions in MySQL with Dreamhost's configuration?