Read 'perldoc DBD::Mysql' for different connect methods. Here is an exert
from the docs...
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password);
Ilya Sterin
-----Original Message-----
From: Simon Chan [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 26, 2001 12:43 AM
To: [EMAIL PROTECTED]
Subject: DBI access from a CGI script
Hey all,
Using a CGI script, I want to access a database from A DIFFERENT server than
the mysql database is
hosted. What is the proper syntax to access the mysql database on a
different server?
They're 2 levels of secruity:
1. Log into Telnet shell
2. Log into database
This is what I have derived from O'Reilly books, though they make the
assumption that you are
running the script from the same server as the database:
$dbh = DBI->connect("dbi:mysql:table1", "$host", "$user", "$password") or
die "Unable to connect";
# table1 is the name of database.
>From this code, it doesn't appear to be able to connect to the database,
perhaps due to the FIRST
level of secruity.
Any help would be appreciated. Many thanks.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
