When you access MYSql from another machine, you need to set the access privilege for that account. You can search the net on how to do this.
ted -----Original Message----- From: Joseph Alotta [mailto:[EMAIL PROTECTED] Sent: Monday, October 02, 2006 9:46 AM Cc: Mac OS X Perl Subject: Re: Perl, MySQl and Airport 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 Hi everyone, I am getting this error, having tried all the combinations. Is there a control panel somewhere that I need to set permissions? I already tried things in "Sharing". 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.
