MySQL Forums
Forum List  »  MySQL Query Browser

Create a Stored Procedure
Posted by: Richard Pupko
Date: January 05, 2011 08:04PM

I use the MySQL Query Browser to access a MySql installation on a server in our network. When I log in I can

SELECT * FROM myTable
UPDATE myTable
CREATE myTable
etc.

I'm new to working with Stored Procedures so I tried to create a very simple one. In the Query Browser Query Area I entered

CREATE PROCEDURE `mySchema`.`temp`()
Select * from myTable;

and got an error message
"Access denied for user 'root'@'%' to database mySchema

I'm not a DBA so could somebody give me some advice on how to get the proper access?

Thanks to all..............Rich

Options: ReplyQuote


Subject
Written By
Posted
Create a Stored Procedure
January 05, 2011 08:04PM


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.