From: Hal Vaughan
Date: March 19 2003 8:53pm
Subject: Cannot access MySQL from Perl after Upgrading to 4.0 (On Linux)
List-Archive: http://lists.mysql.com/perl/2100
Message-Id: <200303191553.12518.hal@thresholddigital.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm using Mandrake Linux 8.2 (upgraded the RPMs to 9.0).  It originally h=
ad=20
MySQL 3.23 and I had no trouble using it from Perl.

Last night I upgraded to MySQL 4.0.x.  It wasn't a straight upgrade -- I=20
basically copied the old files to backup directories and installed 4.0.x =
new.

Now whenever I try to access MySQL from Perl (using the DBI interface), I=
 get=20
this error:

DBI connect('database=3Dlopas','hal',...) failed: Can't connect to local =
MySQL=20
server through socket '/var/lib/mysql/mysql.sock' (2) at test.pl line 11
Can't connect

There is no socket file (mysql.sock) in the /var/lib/mysql directory (thi=
s is=20
the MySQL data dir on this system).  (I can't find one in the backup=20
directory either, but it is possible I outsmarted myself and somehow dele=
ted=20
it.)

I searched mysql.com and found a few things similar to my situation.  One=
 is=20
to check on the socket with this command line:

mysqladmin --protocol=3Dsocket --socket=3D/tmp/mysql.sock version

which I did, and got this error:

mysqladmin: ERROR: unknown variable 'protocol=3Dsocket'

So why am I getting this error for something mysql.com is telling me to d=
o (I=20
notice when I do mysqladmin --help, --protocol is no mentioned at all)?

And, most important, how do I get Perl working with MySQL again?

Thanks for any help or suggestions (or even a URL for the M to RTF!)

Hal