Create a Stored Procedure
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
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.