> I am changing a database and changing the user and password of an > existing > database. when I enter the line. > > mysql> insert into user (host, user, password) values ('localhost', > 'newuser', password ('newpswrd')); > > the error 1062: Duplicate entry 'localhost-newuser' for key 1 > mysql>
Since you are changing the password you should be updating not inserting. The error means you already have an entry for [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]