can u please try this a root user mysql -uroot
regards anandkl On 4/18/08, kabel <[EMAIL PROTECTED]> wrote: > > I'm attempting to create a MySQL stored procedure, however, when I attempt > to > create even a simple "Hello, world" procedure, I get the following error: > > ERROR 1307 (HY000): Failed to CREATE PROCEDURE test_procedure_k > > which is listed as: > > Error: 1307 SQLSTATE: HY000 (ER_SP_STORE_FAILED) > Message: Failed to CREATE %s %s > > I've googled for the solution, and the only problems I can find are people > who > haven't upgraded correctly. This is a clean installation, though, and I > don't recall any errors when installing. I'm not ruling anything out, but > I > don't think that's the case. > > The results of mysqlcheck mysql for the proc tables are: > > mysql.proc OK > mysql.procs_priv OK > > > Anyone have any thoughts, or come across this before? > > TIA, > > kabel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >