Accessing your MySQL database with Perl

Article Details
Article ID: 203
Created On: 20 Sep 2007 03:16 PM


The Perl module, is a convenient way to connect to the database from within Perl scripts. Please read the documentation about Full documentation for the Perl module use is available from this link

Please be advised that Mochahost can not support your custom programming or scripts.

Here are the basics of connecting: NOTE: substitute the following values in the script below:

$hostname = "Your-DB-Server-Hostname" (NOTE: We use Remote MySQL servers for most shared packages, check this article for details on what your hostname might be).

$database = the new database

$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);