perl - help troubleshooting dbi statement that uses double and single quotes
my $dbh = DBI->connect("DBI:mysql:database=$dbsrc;host=$node",'foo-bar','mypw');

my $dbh = DBI->connect("DBI:mysql:database=$dbsrc;host=$node", '$user','$pw');

my $dbh = DBI->connect("DBI:mysql:database=$dbsrc;host=$node", $user,$pw);

DBI connect('database=;host=hostname','',...) failed:

my $dbh = DBI->connect("DBI:mysql:database=$dbsrc;host=$node;mysql_compression=1;port=3306", $user,$pw);

my $dbh = DBI->connect("DBI:mysql:database=$dbsrc;host=$node;mysql_compression=1;port=3306", '$user','$pw');