CakePHP application MySql error

Pratik Samudra

• March 30, 2017 05:51

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.

• 

  cPanelMichael

  • March 30, 2017 14:51

  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.

  0
• 

  Pratik Samudra

  • March 30, 2017 17:29

  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.

  0
• 

  cPanelMichael

  • March 30, 2017 17:57

  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.

  0
• 

  Pratik Samudra

  • April 03, 2017 13:30

  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.

  0
• 

  cPanelMichael

  • April 03, 2017 14:24

  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.

  0

Please sign in to leave a comment.