List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:April 18 2008 2:26pm
Subject:Re: MySQL Stored Procedure error 1307
View as plain text  
can u please try this a root user

mysql -uroot

regards
anandkl


On 4/18/08, kabel <lists@stripped> 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/mysql?unsub=1
>
>

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