Re: Security: MySql - Perl

On Tue, Sep 27, 2005 at 01:54:04PM +0200, ?kos Tomasits wrote:
> 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.

Could you post the part of the Perl script that actually connects to
the database?  There could be some trivial error...

Besides, how exactly have you established that you can do everything
with the MySQL client?  Have you tried it with the "-h localhost" and
"-h 127.0.0.1" options?

G'luck,
Peter

-- 
Peter Pentchev	[email protected]    [email protected]    [email protected]
PGP key:	http://people.FreeBSD.org/~roam/roam.key.asc
Key fingerprint	FDBA FD79 C26F 3C51 C95E  DF9E ED18 B68D 1619 4553
I am jealous of the first word in this sentence.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (FreeBSD)

iD8DBQFDOUjH7Ri2jRYZRVMRAlO1AJ9DVApS/h/jdUGwjKnET72MR9wrdwCbBeCN
lr6+/YZkrqGCsQMihcvxl3A=
=jkG4
-----END PGP SIGNATURE-----