I am having a problem getting this to work and the documentation I have found doesn't seem to be helping, hopefully someone out there can help me.
I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured MySQL exactly as the manual shows in Section 4.3.9 - Using Secure Connections, including 4.3.9.3 - Setting up SSL Certificates. This all works as advertised if I access mysql from the command line. I have a short Perl program which I have included which uses DBI 1.32. I can not get the authentication to work whether I include "$password" or not. I get the following error... [EMAIL PROTECTED]:rac$ dbtest.pl DBI connect('menagerie:localhost;mysql_read_default_file=/home/rac/.my.cnf','rac ',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at /home/rac/perl/src/dbtest.pl line 7 Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) at /home/rac/perl/src/dbtest.pl line 7. [EMAIL PROTECTED]:rac$ Here's the code... #!/usr/bin/perl -w # use DBI; my $query; my $user = "rac"; my $password = "testpass"; my $dbh = DBI->connect("DBI:mysql:menagerie:localhost;mysql_read_default_file=/home/ra c/.my.cnf", $user, $password) || die "$DBI::errstr"; $query=$dbh->prepare("select * from pet") || die "prepare-> $DBI::errstr"; $query->execute; while ((@userinfo)=$query->fetchrow) { print "$userinfo[0]\n"; } $query->finish; $dbh->disconnect; exit 1; Any help will be greatly appreciated, Rich Emerging Software Technology A man of genius makes no mistakes.| Brookhaven National Laboratory His errors are volitional and are | ITD Bldg 515, Upton, NY 11973 USA the portals of discovery | http://www.buoy.com/~rac - James Joyce | mailto:[EMAIL PROTECTED] (631) 344-7975 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]