I was trying to get a MySQL user-defined function working but was getting an error that I don't have permission to access/write to the table 'mysql'.
CREATE FUNCTION myfunc_double RETURNS REAL SONAME "udf_example.so"
Access denied for user 'MYUSERACCOUNT'@'localhost' to database 'mysql'
I believe 'mysql' is responsible for maintaining a list of available functions, and that might cause conflicts on a shared server, but I still need the functionality. I have data that really needs a custom function to prune it at the database level.
Thanks for any help/info!