Accessing your MySQL database with Perl

The Perl module, DBI.pm is a convenient way to connect to the database from within Perl scripts.

Here are the basics of connecting: (Please be advised that we can not support your custom programming or scripts)

Note: substitute the following values in the script below:
$hostname = the database server (i.e. www.jpworld.com), $database = the new database (named after your username), $user = your username and $password = the password you set.

use DBI;
$driver = "mysql";
$dsn = "DBI:$driver:database=$database;host=$hostname";

$dbh = DBI->connect($dsn, $user, $password);

back