MySQL error number 1044 stored procedure creation

[Yoke Yew Tan]

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` ()
BEGIN
select * from d_branch;
END

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.


Regards,
Yoke Yew