You Need Super Privileges for this operation

dueckers5

• June 16, 2016 11:40

i put SELECT @@GLOBAL.sql_mode; SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; and MySQL Said MySQL said: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation what do i do to fix this? i dont have privileges tab to fix it

• 

  ssfred

  • June 17, 2016 05:55

  Hello :) Are you able to log in as the root user for this MySQL server? If so, you can enable the privilege by executing the following command from MySQL shell. mysql> GRANT SUPER ON dbname.* TO user@'localhost' IDENTIFIED BY 'password'; mysql> FLUSH PRIVILEGES; Do remember to change the dummy values such as dbname, user, password etc. with actual values.

  0
• 

  SysSachin

  • June 17, 2016 08:04

  Hello, To set Privileges you need to have root access for the server but I can see that your access level is Website Owner so you need to contact to your hosting provider to check this issue.

  0
• 

  twhiting9275

  • June 18, 2016 15:06

  what do i do to fix this? i dont have privileges tab to fix it
  Contact your host. They'll get you straightened out.

  0
• 

  syslint

  • June 19, 2016 14:32

  i put SELECT @@GLOBAL.sql_mode; SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; what do i do to fix this? i dont have privileges tab to fix it

  
  You are setting the global sql mode as normal mysql user. You need the root/admin privilege for your mysql server. If you don't own the server, ask to your server provider.

  0
• 

  dueckers5

  • June 23, 2016 05:21

  i switched hosts and now it works thanks anyways guys!

  0
• 

  cPanelMichael

  • June 23, 2016 18:29

  Hello, I'm happy to see the issue is now addressed. Thank you for updating us with the outcome.

  0
• 

  friv

  • May 07, 2020 06:01

  Same problem here

  0

Please sign in to leave a comment.