MySQL installation problem

[riscphree]

Ok, running FC2 and tried to install Mysql from source, I followed the installation from mysql's site and get this error:

[root@localhost mysql]# bin/mysql_install_db --user=mysql
Installing all prepared tables
ERROR: 1062  Duplicate entry 'localhost-root' for key 1
ERROR: 1062  Duplicate entry 'localhost-' for key 1
Fill help 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 '' at line 1
051218 19:28:40 [ERROR] Aborting

051218 19:28:40 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

bin/mysql_install_db: line 299: 18218 Broken pipe             cat $fill_help_tables

WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED!
The "HELP" command might not work properly


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

I dont know what that syntax error is ..

and here is the error I get when I try to start it:

[root@localhost mysql]# bin/mysqld_safe --user=mysql Starting mysqld daemon with databases from /usr/local/mysql/var STOPPING server from pid file /usr/local/mysql/var/localhost.pid 051218 19:49:45 mysqld ended

The reason why I did not use yum to get mysql is because it gave me an old version (3.23) and as you know .. thats reallly old. This is mysql 4.1.16.

Anyone have a take on it?

[gavinw6662]

did you read the install guide found in the directory?? I think that there is normally some ./configure arguments you have to feed it to get it to work. Like most importantly the directory for install.

[riscphree]

yup, I did that when I installed it.