The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 5 & Stored Procedure Permissions

Discussion in 'General Discussion' started by rugby148, Mar 7, 2007.

  1. rugby148

    rugby148 Registered

    Joined:
    Mar 7, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    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.
     
  3. rugby148

    rugby148 Registered

    Joined:
    Mar 7, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I can't even get it to take from shell cmd line. I still get permission denied.
     
Loading...

Share This Page