Creating MYSQL Functions

Asked by:
FrankP / 5 Points
Time:
2012-05-18 1:17 pm EST
Category:
Databases
Hits:
574
I'm attempting to create a function within one of my DBs but am receiving the error message "Access denied; you need the SUPER privilege for this operation". The user I'm running this under has all available permissions that I can assign via the control panel.

Suggesting?

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

arnelc
Staff
13,291 Points
2012-05-18 2:30 pm EST
Hello FrankP,

Apologies, but there are some permissions that are not given to users in the MySQL database, in spite of the fact that it appears that you may have ALL of the permissions. For security purposes, full privileges for users on MySQL are not given. The primary permission that is not given is the "EXECUTE" permission - I know it appears to be available, but no users actually have it. If you can set your function to not require this permission, then you will be able make it work. Otherwise, there will be no way that your created function will work.

If you have any further questions, please contact technical support or leave a comment at the bottom of the page.

Regards,

Arnel C.

To submit a comment on this answer, please first login.

Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.