Install problems on Red Hat Linux

I'm attempting to install MySQL on my Red Hat Linux box (now running KDE). Whilst I had it working before under GNOME, I reformatted because it had ceased to work when I corrected a hostname mistake I had made on install.

However, it now won't install at all! I am following the "Setting up database driven websites" article from Devshed to try and get it installed. I get as far as the part when you run the /usr/local/mysql/scripts/mysql_install_db script, and when I try and do that, everything goes pear-shaped. I get this:

[mysql@localhost mysql]$ scripts/mysql_install_db
Creating db table
Creating host table
Creating user table
Creating func table
Creating table_priv table
Creating column_priv table
ERROR: 1062 Duplicate entry `localhost-root` for key 1
ERROR: 1062 Duplicate entry `localhost-` for key 1

To start mysql at boot time ....

My guess is that when the script tries to create the column_priv table, two entries try and use the same value for a primary key. But what would these be, and how can I remedy the problem???

--------------------------------------------
Alex
(http://www.alex-greg.co.uk)

so your having problems installing it? or setting up the databases?

------------------
-Casey

if its an install problem, then

1. login as root, or use "su"
2. ftp to ftp.mysql.com username=anonymous password=(your email address)
3. change directory to MySQL-3.22 (note, it is case sensitive)
4. get MySQL-client-3.22.32-1.rpm (note, it is case sensitive)
5.exit from ftp with "bye"
6. go to http://www.mysql.com/documentation/...ction=Linux-RPM
7.follow the instructions step by step.
8. DO NOT RESTART mysqld until you are sure it will restart, this happened to me, and i had to spend quite a while getting it back up.


------------------
-Casey

"get MySQL-client-3.22.32-1.rpm"

Doesn't exist: instead there are:

MySQL-client-3.22.32-1.alpha.rpm
MySQL-client-3.22.32-1.i386.rpm
MySQL-client-3.22.32-1.mips.rpm
MySQL-client-3.22.32-1.ppc.rpm

Which one? I'm running Red Hat on an i486

--------------------------------------------
Alex
(http://www.alex-greg.co.uk)

You will want to use i386 versions for your Intel 486 chip.