Hi,

I am getting the following error message while I am trying to run "mysql_upgrade -uroot -proot --basedir=/" on the root directory - "Can't find program 'mysqlcheck'
Please restart with --basedir=mysql-install-directory". I am using 5.0.41 community-log edition.

Doing this mysql_upgrade since I got Error:1307 - Failed to execute Stored Procedure.

If you look at the message returned it says "--basedir=mysql-install-directory". You have passed in the root / directory. Find where mysql is installed and set basedir correctly and retry.

When i ran ps -ef | grep mysql it shows "basedir=/" and for whereis mysl it showed me the following paths "mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz" But when I tried to run from all these paths it is showing same error. for eg, "mysql_upgrade -uroot -proot --basedir=/usr/bin/mysql"

Whereas I am able run mysqlcheck from the root / directory.