Greetings everyone,
This is where I got to on the mySQL. It seems like there is someone
on the Mac to set
permissions. I tried the Sharing Control Panel. Where else should I
try?
Hosea:/Library/MySQL/bin jja$ /Library/MySQL/bin/mysql -u root -D
names -h Yeshua.local
ERROR 1130: Host '10.0.1.4' is not allowed to connect to this MySQL
server
Hosea:/Library/MySQL/bin jja$
Joe.
On Sep 26, 2006, at 12:23 PM, Sherm Pendley wrote:
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
