use DBI;

...

my $db_handle = DBI->connect( "DBI:mysql:database=$dbname;host=$hostname",
                              $username, $password ) or
   die "MySQL connection failed: $DBI::errstr";

...

# make up an sql statement string and a set of parameter values
# and execute it, as suggested in jeffa's reply...