Re: Connecting to mysql using DBI and a non-standard socket

Why do you need connect via a the socket file? Presumably your mysql instance is listening for connections on a particular port number (default is 3306). In which case, you could use the command line

mysql -h localhost -P <port> -u root --password=password nemo
[download]

which would translate in DBI to

my $dbh = DBI->connect("DBI:mysql:database=nemo;host=localhost;port=$p
+ort", 'root', 'password', \%attr);
[download]

Ivan Heffner
Sr. Software Engineer, DAS Lead
WhitePages.com, Inc.

Comment on Re: Connecting to mysql using DBI and a non-standard socket Select or Download Code

Replies are listed 'Best First'.
Re^2: Connecting to mysql using DBI and a non-standard socket by gellyfish (Monsignor) on Jul 05, 2005 at 20:18 UTC
You might not want to have your `mysqld` listening on a TCP socket if there is no need for a client on another host to access the database. It makes for a more secure installation for one thing. /J\	[reply] [d/l]