mysql5 mysql_upgrade doesn't work after upgrading to 5.0.24

[opendarwin-2006@…]

I understand you're supposed to run mysql_upgrade after you upgrade to a new version of MySQL. But after upgrading to MySQL 5.0.24, mysql_upgrade doesn't seem to work anymore.

(I have /opt/local/bin, /opt/local/sbin and /opt/local/lib/mysql5/bin in my PATH.)

$ mysql_upgrade5 Can't find program '/opt/local/bin/mysqlcheck' Please restart with --basedir=mysql-install-directory $ mysql_upgrade Can't find program '/opt/local/bin/mysqlcheck' Please restart with --basedir=mysql-install-directory $ mysql_upgrade --basedir=/opt/local/lib/mysql5/ Can't find data directory. Please restart with --datadir=path-to-data-dir $ mysql_upgrade --basedir=/opt/local/lib/mysql5/ --datadir=/Users/rschmidt/mysql/data/ [snipped usage message for mysqlcheck] Could not find file mysql_fix_privilege_tables.sql Please use --basedir to specify the directory where MySQL is installed $

I don't know what to specify now. And it seems to me like I shouldn't have to specify anything -- that it should already know where its parts are. In 5.0.22 the script worked fine without specifying anything extra, but I read in the release notes that between 5.0.22 and 5.0.24 they rewrote mysql_upgrade and changed it from a shell script to a C program. I'm guessing that has something to do with this problem.