Problem importing database

[fotinis]

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!

 

[Faris Raouf]

Are you running this query when logged in to mysql as "admin"?

If so then I'm stumped!

 

[Amin Taheri]

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.