Description:
Installing all prepared tables
ERROR: 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"REPLACE works exactly like INSERT, except that if an old\nrecord in the table h' at line 1
040416 7:29:07 Aborting
040416 7:29:07 /usr/local/mysql/libexec/mysqld: Shutdown Complete
./mysql_install_db: line 276: 21692 Broken pipe cat $fill_help_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!
How to repeat:
Go through install instructions until command 'bin/mysql_install_db
Specs:
Redhat 8 C Compiler gcc 3.2-7
Redhat 8 C++ Compiler g++ 3.2-7
mysql-5.0.0-alpha
Suggested fix:
I did find a very similar error output from error ID# 2872 however this person had a different OS and is getting a different possible solution to the error message. I did try all suggestions from this error message with no success.
Robb Fenwick
