MySQL Forums
Forum List  »  MySQL Administrator

MySQL error number 1044 stored procedure creation
Posted by: Yoke Yew Tan
Date: August 03, 2009 03:15AM

I have one database called `test_yy` which has a table called `d_branch`. I'm trying write one stored procedure by using MySQL Administrator 1.2.12 to create the SP. First I clicked on the database `test_yy1 and clicking to the "Create Stoted Proc" button then one new window is coming and I put the following code on it,

CREATE PROCEDURE `test_yy`.`procedure1` ()
select * from d_branch;

But if I click "Execute SQL" button then it is giving me the
"MySQl error number 1044" error,
Access denied for user 'root'@'%' to database 'test_yy'

Can anybody tell me what's wrong there? Thanks in advance.

Yoke Yew

Options: ReplyQuote

Written By
MySQL error number 1044 stored procedure creation
August 03, 2009 03:15AM

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.