MySQL installation problem

[riscphree]

I cannot get mysql working. This is a Fedora Core 2 installation, I tried installing mysql with yum (it installed the 3.23 version, I dont want

that). I tried upgrading, that did not go so well. I tried installing from the binaries, well, that didnt go to well either. So this is from the

source installation.

this is the error I got whilst installing:

[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

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

Anyone have a take on this?