MySQL Forums :: Perl :: DBI connect(...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Luca Longo wrote:

> adcycle@vps:~/public_html/cgi-bin$ perl test.pl
> DBI connect('database=adcycle','adcycleuser',...) failed: Can't connect to local MySQL server
> through socket '/var/run/mysqld/mysqld.sock' (2) at test.pl line 13

You should check whether your MySQL is running with this socket:

mysql> show variables like 'socket';

If another socket is returned, try to connect with that one as follows:


my $dbh = DBI->connect("$driver:database=$database;mysql_socket=/another/socket.sock", $user, $pass)

--
felix
Please use BBCode to format your messages in this forum.