Hello
How can I fix the following script [1] to get get around this error. How the proplem row be dropped ?
Thanks Glenn

# mysql < genschema.sql
ERROR 1062 (23000) at line 4: Duplicate entry 'localhost-cacti' for key 'PRIMARY'

[1]
# cat genschema.sql
use mysql;
DROP DATABASE IF EXISTS cactidb;
DROP SCHEMA IF EXISTS cacti;
INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'cacti', PASSWORD('cactipw'), 'Y', 'Y', 'Y');
flush privileges;
SELECT host, user, password FROM user WHERE user = 'cacti';
create database cactidb;
GRANT ALL PRIVILEGES ON cactidb.* to 'cacti'@'%' IDENTIFIED BY 'cactipw' WITH GRANT OPTION;
flush privileges;
show databases;
exit

This means you are trying to enter a same value for the primary key (must be unique) check ur table for the primary key column. Then go from there. ie, is host, user password select_priv..etc? which one is the primary key?
post the result of this: