You Need Super Privileges for this operation

warmwhisky

• December 21, 2017 23:35

Regarding the below quote. Please can you explain how and where I do this? I have logged in to SSH as root then executed "mysql -uroot -p" then executed the below, but it still doesn't work. I have changed the dummy text to my credentials and db. The error I receive is Incorrect usage of DB GRANT and GLOBAL PRIVILEGES I have also tried this
GRANT ALL ON DB_NAME.* TO 'USER'@'HOST' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
But it says zero rows effected I have also tried this
GRANT SUPER ON DB_NAME.* TO USER@'localhost' IDENTIFIED BY 'PASSWORD';
Again zero row effected How do I create and run stored procedures in my app? It works fine on my local copy.

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.

• 

  rpvw

  • December 22, 2017 07:29

  You might like to review the following thread for some excellent advice from the cPanel staff regarding databases and users. unable to create a database from mysql command line

  0
• 

  warmwhisky

  • December 22, 2017 11:48

  My mistake, I already had the permissions to create procedures. But when I exported my procedure from my local machine I picked up a DEFINER that had an incorrect user "root" attached. I removed the DEFINER and the procedure was created successfully.

  0
• 

  cPanelMichael

  • December 22, 2017 16:38

  Hello, I'm glad to see you were able to solve the issue. Thank you for sharing the solution.

  0

Please sign in to leave a comment.