tsnradix
3-22-06, 04:57 AM
I am trying to add my own custom function to my mysql database, via the CREATE FUNCTION system and using the upload SQL file function of phpmyadmin [in order to escape out the new line deliminter's and so forth due to the multiline nature of function code]
It seems to upload ok, but then attempting to execute this function just fails with an error.
It doesn't specifically say the function doesn't exist, but more along the lines of picking on the parameters passed, or even if nothing is passed, it just complains the same way
Now, I do know on my local development server I had to add a "execute" priv to my mySQL user in order to execute a user added function.
But I can't seem to run a grant statement in phpmyadmin . and Update mysql.user is out of the question I'm sure.
Has anyone here utilised a custom user function for mysql and succeeded?
Please tell me how if so.
I really need to get this function in mySQL as there is no other option in the situation I am using it in.
Thank you so very much for your help!
It seems to upload ok, but then attempting to execute this function just fails with an error.
It doesn't specifically say the function doesn't exist, but more along the lines of picking on the parameters passed, or even if nothing is passed, it just complains the same way
Now, I do know on my local development server I had to add a "execute" priv to my mySQL user in order to execute a user added function.
But I can't seem to run a grant statement in phpmyadmin . and Update mysql.user is out of the question I'm sure.
Has anyone here utilised a custom user function for mysql and succeeded?
Please tell me how if so.
I really need to get this function in mySQL as there is no other option in the situation I am using it in.
Thank you so very much for your help!