MySQL-5.0.27 Stored Procedures

[Brian2003]

I get an 'access denied' error when trying to add a stored procedure.
In the cPanel window to grant MySQL user permissions there are no
options for 'Create Routine' or 'Alter Routine'. I have posted a service ticket.

Am I missing something here? Anyone else having this problem?

[Brian2003]

I didn't get a response from my service ticket but I logged into cPanel and
found a new option under MySQL user permissions: 'CREATE ROUTINE'.
I haven't tried it yet but that should fix it.

[Brian2003]

I'm trying to be as patient as I can be.
'create routine' was added but 'execute' was removed.

I sent another support ticket to bluehost to explain I need both.
I don't care what cPanel does or doesn't support, someone from
bluehost can go in and manually fix my user privileges. I shouldn't have
to rewrite my code because they can't get their act together.

I hope this isn't indicative of bluehost technical expertise.

[keypoint]

Same thing with triggers and the SUPER privilege...

[keypoint]

Got an answer: triggers not supported on bluehost databases... Not too happy about that. Have to see if it's worth emulating them or I'm off to find someone that supports them.

[alojamen]

(Post removed by moderator. Posting it once is enough. Posting the same thing in multiple threads really doesn't accomplish anything. http://www.bluehostforums.com/showth...8196#post68196)