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 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:
    0
    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.. :)
     
    #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:
    0
    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..
     
    #4 viraj, May 19, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySql Store Procedure
  1. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    136
    Naila
    Jun 22, 2017
  2. djbaxter

    SOLVED The MySQL restore process died from the “SEGV” signal.

    djbaxter, Mar 11, 2017, in forum: Data Protection
    Replies:
    8
    Views:
    1,240
    cPanelMichael
    Apr 4, 2017
  3. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    360
    cPanelMichael
    Oct 11, 2016
  4. gnusys

    cPanel account restore does not work for remote mysql profile

    gnusys, Feb 6, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    731
    cPanelMichael
    Feb 8, 2016
  5. urgido

    problem with mysql on restored process from cpmove file

    urgido, Aug 22, 2015, in forum: Database Discussions
    Replies:
    9
    Views:
    825
    cPanelMichael
    Sep 4, 2015

Share This Page