Connect to MySQL database (on Ubuntu Server) using Perl

liverpaul has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

I'm having trouble connecting my local Ubuntu 12.04 laptop to my remote MySQL database on my Ubuntu Server 10.04. The Perl code I am using is as follows:

#!/usr/bin/perl
use strict;
use warnings;
use DBI;

my $username='username';
my $pass='password';
my $db='database_name';
my $dbh = DBI->connect( "dbi:mysql:$db", $username, $pass, { 'PrintErr
+or' => 1, 'RaiseError' => 1 } );
[download]

I have Wordpress installed on the server and it works - I can connect to the database. However, when I fill in the same details in my Perl script I get the following error:

DBI connect('database_name','username',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at .....

My server is VPS hosting by the way.

Any ideas? I'm a beginner, so keep it as simple as possible :-)

Comment on Connect to MySQL database (on Ubuntu Server) using Perl Select or Download Code

Replies are listed 'Best First'.
Re: Connect to MySQL database (on Ubuntu Server) using Perl by moritz (Cardinal) on Jul 25, 2012 at 12:23 UTC
Supply a hostname to the `connect` call (localhost if the database server is on the same machine), so that mysql connects through the network. Also I think you have to write `"dbi:mysql:database=$db"`. See DBD::mysql for more information. Perl 6 - the future is here, just unevenly distributed	[reply] [d/l] [select]
Re^2: Connect to MySQL database (on Ubuntu Server) using Perl by liverpaul (Novice) on Jul 25, 2012 at 12:38 UTC
Hi, Thanks for the reply. I've changed my code to this: `#!/usr/bin/perl use strict; use warnings; use DBI; my $username='username'; my $pass='password'; my $db='database_name'; my $host='hostname'; my $dbh = DBI->connect( "dbi:mysql:database=$db:$host", $username, $pa +ss, { 'PrintError' => 1, 'RaiseError' => 1 } );` [download] I'm still getting an error: Unknown MySQL server host 'hostname' (2) at ...	[reply] [d/l]
Re^3: Connect to MySQL database (on Ubuntu Server) using Perl by moritz (Cardinal) on Jul 25, 2012 at 12:45 UTC
Use the real host name, not "hostname". For example "localhost". The documentation of your VPS should tell you what the correct hostname is. Perl 6 - the future is here, just unevenly distributed	[reply]
Re^4: Connect to MySQL database (on Ubuntu Server) using Perl by liverpaul (Novice) on Jul 25, 2012 at 12:57 UTC
Re: Connect to MySQL database (on Ubuntu Server) using Perl by Anonymous Monk on Jul 25, 2012 at 12:33 UTC
Can’t connect to local MySQL server through socket http://www.tech-recipes.com/rx/762/solve-cant-connect-to-local-mysql-server-through-socket-tmpmysqlsock/ Can't connect to local MySQL server through socket site:perlmonks.org Canot connect to the remote mysql server through those lines How do I specify the MySQL socket file? Connecting to mysql using DBI and a non-standard socket	[reply]
Re^2: Connect to MySQL database (on Ubuntu Server) using Perl by liverpaul (Novice) on Jul 25, 2012 at 12:58 UTC
I am looking through these links now - hopefully one of them will help. Thanks.	[reply]
Re^3: Connect to MySQL database (on Ubuntu Server) using Perl by liverpaul (Novice) on Jul 25, 2012 at 20:25 UTC
UPDATE: I found a solution to the problem here: `http://www.ghacks.net/2009/12/27/allow-remote-connections-to-your-mysql-server/` Thanks again for the replies :-)	[reply] [d/l]
Re: Connect to MySQL database (on Ubuntu Server) using Perl by choroba (Cardinal) on Jul 25, 2012 at 12:25 UTC
Do you set hostname and port in $db?	[reply]

Back to Seekers of Perl Wisdom