Re: script not able to connect

Hi Jeremy,

Jeremy Morris wrote on 14.08.2004:

>I am quite new at using perl and mysql.  I just installed 
>the DBI and DBD packages, and was required to download the 
>header files to do so.  Once all these things were 
>installed, I tried a simple script to see if it works. 
> Here is the code I tried:
>
>#!/usr/bin/perl -w
>use strict;
>use DBI; (I also tried use DBD::mysql, same effect)
>
>my $dsn = 'dbi:mysql:databasename:myhostname:3306';
>my $user = 'myusername';
>my $pswd = 'mypassword';
>
>my $dbh = DBI->connect($dsn,$user,$pswd) or die 'try 
>again\n';
>
>I get the follwing error message after running $> perl 
>filename.pl :
>DBI 
>connect('databasename:myhostname:3306','myusername','...) 
>failed: Host 'myipaddress' is not allowed to connect to 
>this MySQL server at filename.pl line 9

Did you set up the MySQL server yourself? Some ISPs offer MySQL databases where access is restricted to their own webservers. This is a good thing from a security viewpoint, but in that case you have to connect to the webserver via ssh and run your script directly from the remote server.

HTH,

Jan
-- 
Either this man is dead or my watch has stopped. - Groucho Marx

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]