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
>
>
