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
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.
I believe it's
The syntax for connecting to a mysql database from perl/DBI is
my $dbh =
DBI-connect('dbi:drivername:database:host','username','passwor
d');
If host is ommitted, it presumes localhost.
Eg: $dbh =
DBI-connect('dbi:mysql:testDB:dbserv','$username','$password');
There are more options see
This is well outlined in the DBI perldoc btw ;-)
Andy Sharp wrote:
The syntax for connecting to a mysql database from perl/DBI is
my $dbh =
DBI-connect('dbi:drivername:database:host','username','passwor
d');
If host is ommitted, it presumes localhost.
Eg: $dbh =