Is this a Bug on cPanel / MySQL users?

[Silent Ninja]

When you create MySQL Users on the cPanel, you cannot set to them any super privilege like LOAD DATA INFILE or EXECUTE PROCEDURE, and such advanced stuff that almost no one uses on a Basic Hosting.

Although a client just told me that from the phpMyAdmin (logged in as the cPanel user) he endeed created a Procedure and was able to execute it there, but since the MySQL Client hasn't this privilege, he is not available to use it on his site.

If theese privileges are not available for mysql users, they should also be disabled for the cPanel user's; or viceversa, if they can be enabled (ie. if it's not a security issue), it should be possible to enable those privileges to MySQL Users from the cPanel.

That way, procedures either would, or would not be used (respectively between both cases) and that should affect both the main cPanel user and the dependent MySQL users.

[d_t]

You can set EXECUTE if you use mysql wizard from cPanel.

[Silent Ninja]

You can set EXECUTE if you use mysql wizard from cPanel.

Sure, just tell me where to click...

(It's in spanish, I'm sorry for that)

[cPanelTristan]

EXECUTE only appears as a privilege in the MySQL Database Wizard rather than in the regular MySQL Databases area. Also, it doesn't actually work to enable that option in the wizard in 11.26 versions.

Here's a thread discussing this issue:

MySQL EXECUTE privilege - cPanel Forums