# either
my $dbh = DBI->connect("dbi:mysql:dbname;mysql_server_prepare=1",
     "user","pass");

# or 
$dbh->{ mysql_server_prepare } = 1;