Odelli Posted October 10, 2010 Report Share Posted October 10, 2010 Hi, I didn't want to create a support ticket, as it's a not a big issue, but as you may also know creating MySQL stored procedures needs higher privileges than a db normal user. I have a query with a lot of joins that I want to convert to a stored procedure. Is there way to do it, with or without support's help? Quote Link to comment Share on other sites More sharing options...
Tony Posted October 10, 2010 Report Share Posted October 10, 2010 cPanel does not support stored procedures right now via MySQL. I believe your main cPanel user may have access to do it but any other user you create will not. We'll be unable to add the permissions for other users as it adds an element of manual work which is something we avoid as it can lead to things breaking down the line for users as the panel is not aware of the changes we make. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.