List:General Discussion« Previous MessageNext Message »
From:kabel Date:April 18 2008 1:49pm
Subject:MySQL Stored Procedure error 1307
View as plain text  
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
Thread
MySQL SlaveKaushal Shriyan18 Apr
  • Re: MySQL SlaveBen Clewett18 Apr
    • MySQL Stored Procedure error 1307kabel18 Apr
      • Re: MySQL Stored Procedure error 1307Ananda Kumar18 Apr
        • Re: MySQL Stored Procedure error 1307kabel18 Apr
    • Re: MySQL SlaveKaushal Shriyan18 Apr