try to create a function like below in mysql:
DROP FUNCTION IF EXISTS `GetRandomSentence`;
CREATE FUNCTION `GetRandomSentence`(`MaxWordCount` INT, `MaxWordCharacters` INT) RETURNS text CHARSET utf8
it says that I have no super user privileges. So how can I create a function?
Hi @Flyfish, thanks for posting.
If you are using a shared or web hosting plan, functions that require super user privileges would be unavailable. You would want to edit the function to not require super user privileges or use an alternate method.
I have the same question about create routines and triggers in MySql database. If I don't have privileges to create routines and triggers, how can I host my website here? MySql error #1419 says that I *might* want to use less safe mode by setting bin_log_trust_function_creator to 1, but again, I don't have SUPER privilege to modify the flag. So how this issue be solved?
Thank you for your help!
If your site requires permissions or access to functions that are not supported on the Web Hosting, then your site might not be compatible with it. You may want to consider using a VPS, so that you have more control over the permissions of your server and account.