SEO

#1 (**permalink**) 02-28-2008, 10:32 AM

Hi all,
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....

Thanks in advance

#2 (**permalink**) 02-28-2008, 10:32 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

mysql-stored procedures