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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

CakePHP application MySql error

Discussion in 'Database Discussions' started by Pratik Samudra, Mar 30, 2017.

  1. Pratik Samudra

    Pratik Samudra Registered

    Joined:
    Mar 30, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Tokyo
    cPanel Access Level:
    Website Owner
    I have followed all the steps as mentioned in the tutorial video.

    1. Created user
    2. Created database
    3. Added user to database and gave "All Privileges"
    4. In my Cakephp 3 application mentioned the appropriate credentials
    And I get the following error

    Error: SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the SUPER privilege(s) for this operation

    After creating the database I use migration to create tables.

    I cannot give any additional privileges using phpadmin.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,419
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You won't be able to grant the SUPER privilege to a database user with cPanel access alone. Assigning this privilege requires root access to the system.

    Thank you.
     
  3. Pratik Samudra

    Pratik Samudra Registered

    Joined:
    Mar 30, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Tokyo
    cPanel Access Level:
    Website Owner
    Thank you for responding.
    Yes I understand that after I did some research. Can you suggest an alternative method to connect my cakephp application to the database on cpanel ? At least the basic privileges like INSERT, SELECT, UPDATE, DELETE should be available.
    I had selected all privileges from cpanel MySql settings, it still throws the above error.

    Is there a possible way to connect cakephp application ?

    Thank you.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,419
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You'd need to check with the developer or support team of the application to determine if there are any workarounds available when the SUPER privilege isn't granted to the database user.

    Thank you.
     
  5. Pratik Samudra

    Pratik Samudra Registered

    Joined:
    Mar 30, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Tokyo
    cPanel Access Level:
    Website Owner
    Hello, thank you for responding.
    Unfortunately, the developer who designed the website is unreachable. Is there any manual or workaround that you can suggest to deploy a cakephp 3 application over cpanel ? I seem to encounter problem when it comes to database only and I have changed the database credentials as per online solutions.

    Sorry to bother you again and again.
    Thank you.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,419
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You could try posting on their support forums to see if a workaround is available when that MySQL privilege isn't available:

    CakePHP Official Forum

    Thank you.
     
Loading...

Share This Page