Security: MySql - Perl

Hi!

Sorry, I am a beginner with Perl.

I try to connect to a MySQL database whith a perl script but I always 
get the following error:
"DBD::mysql::st execute failed: SELECT command denied to user: 
'logger@localhost' for table 'category'..."

I have granted all of the priviledges to the user logger by this mysql 
console command:
GRANT ALL PRIVILEGES ON logger
TO 'logger'@'localhost'
IDENTIFIED BY 'logger';

GRANT ALL PRIVILEGES ON logger
TO 'logger'@'%'
IDENTIFIED BY 'logger';

use mysql
update user set select_priv='Y' where user="logger";


With the bin/mysql client I can connect and do everything on the above 
database as "logger", but from the PERL script I cannot.

Thank you!
Akos Tomasits



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]