• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Problem importing database

F

fotinis

Guest
Hello everyone, I am trying to import a database but I keep having the following error

Error
SQL query:

CREATE DEFINER = `root`@`localhost` PROCEDURE `l4zlm_TeraWurfl_FallBackDevices` ( current_fall_back VARCHAR( 64 ) ) BEGIN WHILE current_fall_back != 'root' DO SELECT capabilities
FROM l4zlm_TeraWurflMerge
WHERE deviceID = current_fall_back;

SELECT fall_back
FROM l4zlm_TeraWurflMerge
WHERE deviceID = current_fall_back
INTO current_fall_back;

END WHILE;

END$$

MySQL said:

#1227 - Access denied; you need the SUPER privilege for this operation



Any suggestions ?
Thank you!
 
Last edited by a moderator:
You can grant the permissions pretty easily

grant SUPER on *.* to 'user'@'localhost' identified by 'passwordHere';
Then flush privileges and you should be good to go.
 
Back
Top