Creating MYSQL Functions

Asked by:
FrankP Time:
2012-05-18 5:17 pm Category:
Databases Hits:
358
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?

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

arnelc
2012-05-18 6:30 pm
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.

You must login before you can post a comment about this answer.
Like this Question?

Support Center Login

Have a Question?

If you need some help, submit your question to our Community! We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)

Recent Questions

  1. Wordpress 404 error
  2. email blocked from specific client
  3. WebCalendar Error While Logging On

Support 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.