On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote:
I have a application in Perl that prints reports from a MySQL
database. I also have DSL that is accessed via Airport in my house.
Recently I bought an iMac for my wife and I want her to help me
print reports from this new computer. How do I get her computer
to get data from the MySQL database that lives on my computer via
Airport?
MySQL client libraries use TCP/IP - they neither know nor care about
the physical network layer. So you'd do this the same way you'd
connect to any other "remote server" - just supply the host name (or
IP address) as part of the dsn.
my $dsn = "DBI:mysql:database=foo;host=192.168.1.101";
my $dbh = DBI->connect($dsn, $user, $password);
If that's not working, some things to check:
• Are the MySQL client libs and DBD::mysql installed on the client?
• Is $user authorized to connect from another host?
• Is MySQL itself configured to allow such connections in general?
sherm--
Web Hosting by West Virginians, for West Virginians: http://wv-www.net
Cocoa programming in Perl: http://camelbones.sourceforge.net
