You have to create a mysql user and
chown -R mysql /usr/local/mysql
Tony Butcher wrote:
>I have compiled 4.0.3-beta onto SuSE Linux 7.0. The configure, make and make
>install go fine, but then when I try to run the mysql_install_db script I
>get a failure.
>Here's the error:
>backup:/usr/local/mysql-4.0.3-beta # ./scripts/mysql_install_db
>Preparing db table
>Preparing host table
>Preparing user table
>Preparing func table
>Preparing tables_priv table
>Preparing columns_priv table
>Installing all prepared tables
>020906 13:20:20 Can't read from messagefile
>020906 13:20:20 Aborting
>Installation of grant tables failed!
>Examine the logs in /usr/local/mysql/var for more information.
>You can also try to start the mysqld daemon with:
>/usr/local/mysql/libexec/mysqld --skip-grant &
>You can use the command line tool
>/usr/local/mysql/bin/mysql to connect to the mysql
>database and look at the grant tables:
>shell> /usr/local/mysql/bin/mysql -u root mysql
>mysql> show tables
>Try 'mysqld --help' if you have problems with paths. Using --log
>gives you a log in /usr/local/mysql/var that may be helpful.
>The latest information about MySQL is available on the web at
>Please consult the MySQL manual section: 'Problems running
>and the manual section that describes problems on your OS.
>Another information source is the MySQL email archive.
>Please check all of the above before mailing us!
>And if you do mail us, you MUST use the /usr/local/mysql/bin/mysqlbug
>It complains that it can't read the messagfile errmsg.sys, but I know it's
>there! Here it is:
>backup:/usr/local/mysql-4.0.3-beta # l
>-rw-r--r-- 1 root mysql 12183 Sep 2 17:34
>Is anyone else getting this? Any ideas how to get round it?