Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySql Store Procedure

Discussion in 'General Discussion' started by persiasoft, May 18, 2008.

  1. persiasoft

    persiasoft Active Member

    Joined:
    Nov 15, 2004
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    151
    Does cPanel support mysql store procedure ?

    i get "you need the SUPER privilege for this operation" when im trying to use procedures.
     
    #1 persiasoft, May 18, 2008
  2. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    1
    Trophy Points:
    166
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Yes cPanel supports MySQL Stored Procedures & you'd [the DB user would] need atleast executable permissions to run them from your scripts. :cool:
    Login to the PHPMyAdmin as root & assign proper permissions to the user such that it can execute the SPs from the scripts.. :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 viraj, May 18, 2008
  3. persiasoft

    persiasoft Active Member

    Joined:
    Nov 15, 2004
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    151
    what about trigger ?
     
    #3 persiasoft, May 19, 2008
  4. viraj

    viraj Well-Known Member

    Joined:
    Sep 28, 2006
    Messages:
    209
    Likes Received:
    1
    Trophy Points:
    166
    Location:
    India
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Hi,

    Stored Procedures are different from Triggers :)
    Triggers require SuperUser permissions due to the effect they can do, not only on the databases but on the database server..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 viraj, May 19, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySql Store Procedure
  1. sodapopinski

    Restore mysql database to server with maria DB?

    sodapopinski, Oct 19, 2017, in forum: Database Discussion
    Replies:
    1
    Views:
    617
    cPWilliamL
    Oct 19, 2017
  2. postcd

    Restore backups/import without MySQL resetting mysql passwords?

    postcd, Aug 30, 2017, in forum: Data Protection
    Replies:
    5
    Views:
    899
    cPanelMichael
    Mar 22, 2018
  3. postcd

    How to restore all files backups and a mysql separately?

    postcd, Aug 29, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    838
    cPanelMichael
    Aug 31, 2017
  4. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    898
    Naila
    Jun 22, 2017
  5. CristianAugusto

    New Thread UAPI Add MySQL Host doesn't take effect

    CristianAugusto, Mar 20, 2019 at 9:09 AM, in forum: cPanel Developers
    Replies:
    0
    Views:
    38
    CristianAugusto
    Mar 20, 2019 at 9:09 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice