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