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)
