MySQL Forums
Forum List  »  MySQL Administrator

Posted by: Vinay KD
Date: March 03, 2010 09:12PM

I am using MySql on Windows XP SP2,
And MySQL Administrator GUI Tool for manipulating the database.

I created a database "testdatabase" from root login.

I created a user "testuser" and set all the privileges to it.

Then i logged to "testuser" and started to restore a database file "testdatabase.sql" which was created on another system for "testdatabase" under root.

I opened the file in a texteditor and replaced all "root" with "testuser"

at the time of restoring at my system it is creating all the tables but when it restores the Views or stored procedures it raises the following error :

Error while executing this query:CREATE DEFINER=`testuser`@`localhost` PROCEDURE `sp_browsebyctg`()
Select * from disp_browsebyctg;
END $$
The server has returned this error message:Access denied; you need the SUPER privilege for this operation
MySQL Error.

Please help me what should i do ???

Options: ReplyQuote

Written By
March 03, 2010 09:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.