use strict;
use warnings;
use DBI;

my $db = 'homo_sapiens_core_42_';
my $host = '192.168.1.200';
my $user = 'xx';
my $pass = 'yy';

DBI->trace(1);
print "HERE\n";

my $dbh = DBI->connect("DBI:mysql:$db;host=$host", 
                       $user, $pass, { RaiseError => 1 } ) or
   die ( "Couldn't connect to database: " . DBI->errstr );

print "DONE\n";

##</code><code>##

    DBI 1.54-ithread default trace level set to 0x0/1 (pid 25943) at query_ensembl.pl line 23
HERE
    -> DBI->connect(DBI:mysql:homo_sapiens_core_42_;host=192.168.1.200, xx, ****, HASH(0x9fc8c28))
    -> DBI->install_driver(mysql) for linux perl=5.008005 pid=25943 ruid=56 euid=56
       install_driver: DBD::mysql version 4.004 loaded from /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-m
ulti/DBD/mysql.pm
    <- install_driver= DBI::dr=HASH(0xa063d18)
    !! warn: 0 CLEARED by call to connect method

##</code><code>##

$ /usr/local/mysql-standard-5.0.27-linux-i686-glibc23/bin/mysql -u xx -h HOST -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3100 to server version: 5.0.27-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> use homo_sapiens_core_42_
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

[deleted test select query]

SELECT query successful.