8 messages in com.mysql.lists.perlRe: Can't connect to local MySQL serv...
FromSent OnAttachments
Arthur H Wakida03 May 2006 12:28 
Mike Blezien03 May 2006 12:44 
Arthur H Wakida03 May 2006 13:50 
Mike Blezien03 May 2006 14:06 
Arthur H Wakida03 May 2006 14:15 
Vladimir V. Kolpakov03 May 2006 14:46 
Marco Wise03 May 2006 15:08 
Arthur H Wakida03 May 2006 15:19 
Subject:Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
From:Mike Blezien (mick@frontiernet.net)
Date:05/03/2006 12:44:26 PM
List:com.mysql.lists.perl

Arthur,

the Error 13 means Permission Denied. check the ownership of the sock file, is should be owned by the "mysql" user if owned by 'root', then this maybe causing your problems.

Mike

----- Original Message ----- From: "Arthur H Wakida" <ahwa@yamada.com> To: <pe@lists.mysql.com> Sent: Wednesday, May 03, 2006 2:29 PM Subject: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

OS RH Enterprise V4 (kernel 2.5.9-5.EL), Perl 5.8.5, DBI-1.46, DBD-MySQL-2.9004-3.1, MySQL 4.1.7 installed

I can access/update MySQL db via webmin (port 10000) and SQLyog (port 3306) without any problem.

When I try to connect to MySQL db via ; my $hndl = DBI->connect("DBI:mysql:$database", $user, $password) or db_err("Unable to contect to $database", $DBI::errstr);

I get the following message : "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)"

Socket in question does exist in /var/lib/mysql and all directories involved is completely open (777). I've other servers up and running without any problem (albeit different versions). Did I miss something? Any help/ideas is greatly appreciated!