$dbh = DBI->connect("DBI:mysql:gmacfadd_webdb:localhost","gmacfadd_webdev2","webdevpass2",
{PrintError => 0, RaiseError => 1});
####
#! /usr/bin/perl -wT
package WebDB;
use strict;
use DBI;
my $host_name = "localhost";
my $db_name = "gmacfadd_webdb";
my $dsn = "DBI:mysql:database=$db_name;host=$host_name";
# Connect to MySQL server using hardwired name and password
sub connect
{
return (DBI->connect ($dsn, "gmacfadd_webdev2", "webdevpass2",
{PrintError => 0, RaiseError =>1}));
}
sub connect_with_option_file
{
$dsn .= ";mysql_read_default_file=$ENV{HOME}/.my.cnf";
return (DBI->connect ($dsn, undef, undef,
{PrintError => 0, RaiseError =>1}));
}
1; #return true
####
[client]
user="gmacfadd_webdev2"
password="webdevpass2"
####
#! /usr/bin/perl -wT
# intro7b.cgi - use WebDB to connect
use strict; # FORCE ALL VARIABLES TO BE DECLARED BEFORE USE
use DBI; # IMPORT THE DATABASE INTERFACE METHODS
use CGI qw(:standard);
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);
use lib qw(/home/gmacfadd/public_html/cgi-bin/dubois);
use WebDB;
my ($dbh, $sth, $count, $user); # DECLARE VARIABLES
$dbh = WebDB::connect_with_option_file();