Accessing your MySQL database with Perl

MySQL Top    What is MySQL    Accessing 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. sql2.hostingsolutions.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);



For more information, please read the documentation about DBI.pm.

Full documentation for the Perl module use is available from:
http://search.cpan.org/doc/JWIED/Msql-Mysql-modules-1.2214/mysql/lib/DBD/mysql.pm

A tutuorial for Perl/DBI use is available at:
http://hotwired.lycos.com/webmonkey/backend/tutorials/tutorial1.html