How can I run stored procedure in Mysql 5.0 ?
The reference manal says that I have to run the script fix_privilege_tables.sql . But the file is missing.

The script is actually called "mysql_fix_privilege_tables.sql", ...if that helps. And it's located in the "scripts" folder of the mysql installation. I've installed MySQL 5.x on a WinXP machine. Accepting the default installation parameters, the scripted files were placed in a directory called c:\mysql\scripts.

If you're having trouble on a MS-Windows installation, you might want to check the PATH variable and consider any previous installations of MySQL that you might have on the machine. That could be interfering. I had mySQL 4.0.x installed(which installs to c:\mysql-4.0.x) and had some trouble on my system because when I tried to run the "fix" script, Windows kept looking through the 4.0.x installation directories.

Hope this helps...

OK, but I cant find de script .

I have the follow scripts in directory c:\mysql\scripts:

fix_privilege_tables (no extension) and
fix_privilege_tables.sh --> It's same.

#!/bin/sh
# This script is a wrapper to pipe the mysql_fix_privilege_tables.sql
# through the mysql client program to the mysqld server

# Default values (Can be changed in my.cnf)
password=""
host="localhost"
user="root"
sql_only=0
basedir=""
verbose=0
args=""

file=mysql_fix_privilege_tables.sql

# The following code is almost identical to the code in mysql_install_db.sh
...
...
... continue...


that´s it? I can´t run it. It is not SQL syntax.
I think that the script have a:
" create table proc (colum 1 type,....)"

thanks for the atention!

BARBABELA

excuse for the english errors. I'm Brazilian

You're on the right track. I see, in my installation, the two scripts that you do(of course, they're actually named "mysql_fix_privilege..."). But I've also got the "mysql_fix_privilege_tables.sql" file, that you seem to be missing.

Either your copy of MySQL was flawed and didn't come with the script, or the script was accidentally deleted/renamed/moved on your PC. I'd suggest reinstalling mysql(probably uninstall current copy first). If that doesn't work then, if it's possible, download a fresh copy of mySQL and reinstall. Maybe choose a different mirror to download from?

Your English is fine...and it's certainly better than my Portuguese!