Error when update Geoip

Peter Farrow peter at farrows.org
Thu Apr 3 16:02:14 IST 2008


Linuxmail R. wrote:
> Dear All
>
> I got this error when i update GeoIp,pls help me. thx..
> -------------------------------------------------------------------
> Downloading file, please wait....
> Error executing query:
>
> Access denied for user 'mailwatch'@'localhost' (using password: YES)
>
> SQL:
>
> LOAD DATA INFILE '/home/crisgo/mailscanner/temp/GeoIPCountryWhois.csv' INTO TABLE geoip_country FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>
> --------------------------------------------------
> Linuxmail Rapin P.
>
>
> =
>
>
>   
The mysql database password for the user "mailwatch" is incorrect, or is 
not set for access from Localhost.

You'll need to execute a command like this from the mysql CLI:

GRANT ALL ON mailscanner.* TO mailwatch at localhost IDENTIFIED BY 'mailwatch';


If your database is called "mailscanner"

Regards

Pete



More information about the MailScanner mailing list