View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 10:32 AM
Gordon Burditt
 
Posts: n/a
Default Re: mysql-stored procedures

> I have mysql 5.0.58 installeed on linux platform, i want to create
>stored procedures, in mysql prompt if i give create procedure abc()
>select 'abc'; i see error "ERROR 1146 (42S02): Table 'mysql.proc'
>doesn't exist", i am stuck with this. Is there any other prerequisties
>to create stored procedure which is missing.. please help me sending
>proper links or documentation....


If you upgraded to MySQL 5.0.58 from an older version, you should
run mysql_fix_privilege_tables to set up the proc table, among other
things. This script is normally installed in the same directory
as the command-line client 'mysql'.


Reply With Quote