Trying to install MySQL 3.22.32

Anon

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.com)

Anon

If this is a fresh install, then mysql should be creating the tables from scratch and duplicates cannot appear.
As they clearly do appear I guess the tables that mysql is trying to fill are already filled.

Try deleting the databasefiles that mysql want's to generate in the script.

BTW, this has nothing to do with running gnome or kde.

Anon

I've tried deleting the database files - this was suggested before. No success.

Because Primary Key is mentioned, it makes sense that some of the data MySQL is trying to store in its tables duplicates the primary key. What would this data be?

The table that causes the script to die is columns_priv. There are seven columns in this table, and five of them are primary keys. Here is a dump for this table:

CREATE TABLE columns_priv (
Host char(60) NOT NULL,
Db char(60) NOT NULL,
User char(16) NOT NULL,
Table_name char(60) NOT NULL,
Column_name char(60) NOT NULL,
Timestamp timestamp(14),
Column_priv set('Select','Insert','Update','References') NOT NULL,
PRIMARY KEY (Host, Db, User, Table_name, Column_name)
);

So does anyone have any suggestions as to what data might be in the primary key, and why it is the same? Thank you.