こんにちは。松本です。

mysql4.1をRedHat9へrootユーザで全てインストール作業を行ったのですが
mysql_install_dbでエラーが出てしまいました。
エラーメッセージが難しく何が間違っているのかわからず困っています。
又、./confiugre時の --with-mysqld-user=mysqlはつけた方が良いのでしょうか？

■参考URL
http://iwah.jp/notes/sg/www/mysql.html

■インストール方法
# tar zxvf mysql-4.1.1-alpha.tar.gz
# cd mysql-4.1.1-alpha
# groupadd mysql
# useradd -g mysql mysql
# passwd mysql
# ./configure --prefix=/usr/local/mysql
  --with-charset=ujis
  --with-extra-charsets=all
# make
# su
# make install
# ./scripts/mysql_install_db

Installing all prepared tables
ERROR: 1064  You have an error in your SQL syntax.  Check the manual that corres
ponds to your MySQL server version for the right syntax to use near '"REPLACE wo
rks exactly like INSERT, except that if an old\nrecord in the table h' at line 1
040509 10:25:31  Aborting

040509 10:25:31  /usr/local/mysql/libexec/mysqld: Shutdown Complete

./scripts/mysql_install_db: line 274: 31078 パイプが切断されました  cat $fill_he
lp_tables
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
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
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 script!

///* Kouichi.Matsumoto */