MailWatch password (web user)

Information Services lbcadmin at GMAIL.COM
Fri Oct 14 14:55:08 IST 2005

    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]

I am trying to change the password for the MailWatch web user, but am
having problems in doing so.

I am running

CentOS 4.1

I have changed the password in:

from the command line:

mysql mailscanner -u (user) -p
[changed the password]
GRANT ALL ON mailscanner.* TO xxx at localhost IDENTIFIED BY 'password';

flush privileges;

Then when I try to create a MailWatch Web User, I run into this problem

mysql mailscanner -u (user) -p
INSERT INTO users VALUES ('xxxx',md5('password'0,'xxxx','A','0');
ERROR 1062 (23000): Duplicate entry 'xxx' for key 1

So what do I need to do in order to change the password for this user?


------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki ( and
the archives (

Support MailScanner development - buy the book off the website!

More information about the MailScanner mailing list