MySQL 5 & Stored Procedure Permissions

rugby148

Registered
Mar 7, 2007
2
0
151
Is anyone using MySQL on a system with Cpanel? Are things working ok? How do you manage permissions that pertain to MySQL specific enhancements (particularly views and stored procedures)?

I am running MySQL 5.0.24, PHP 5.2.1 and Cpanel 10.9.0-STABLE 119.

Cpanel does not properly reflect the MySQL version and consequently does not have any parameters for setting permissions for these additional MySQL features that I can find.

Does anyone have any suggestions?
 

cPanelKenneth

cPanel Development
Staff member
Apr 7, 2006
4,608
79
458
cPanel Access Level
Root Administrator
The fix for that is only in EDGE (it may be in CURRENT now, I don't know).

Possibly the best ways to do it in STABLE are:

1. manually at the command line
2. Manually via PHPMyAdmin
3. Create a script that grants these privileges.

There might already be a script that does it, try searching the forum.