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/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php