Its a permissions thing on the server end. You have to have set up a user
account on the server. Very important are hostnames.
Curtis
John Almberg said:
> I'm trying to set up a remote connection to a mysql database using Perl
> DBI. I have done this without problem on another database. I suspect the
> rights are set up differently on this one. I have root access.
>
> When I try to connect, I get the following error (hostname, username,
> password have been edited for the purpose of this email):
>
> DBI connect('database:host','user','password') failed: Host
> 'ool-182f1a5f.dyn.optonline.net' is not allowed to connect to this MySQL
> server at D:\My Documents\Identry Shared\Operations\Stamp Center --
> website\database\update_inv.pl line 7
>
> After reading section 4.2.8 in the manual (Connecting to the MySQL
> Server), I am pretty sure this is a rights problem. The user I am trying
> to connect as has 'localhost' set in the Host field of both the 'user'
> and 'db' tables. There are no entries whatsoever in the 'host' table.
>
> What I want to do is to add the ability for my Perl program to connect
> as a certain user (call him 'bob') from a certain IP address.
> Unfortunately, all my attempts result block access from every host, even
> localhost. Thus, even the webserver can't access the database.
>
> In desperation, I've even tried using '%' in the Host fields of both
> user & db tables. This doesn't work, either, so I'm obviously missing
> something.
>
> Any help much appreciated!
>
> Brgds: John
>
> ------------------------------------------------
> Identry, LLC
> Northport, NY 11768
>
> Ph: 631.754.8440
> Fx: 631.980.4262
> Em: [EMAIL PROTECTED]
>
> Member: ASDA, APS, ANA, Ephemera Society
> of America, Long Island Web Developers Guild
>
> <><><><><><><><><><><><><><><><><><><><><><><><>
> Visit us at: www.identry.com
> Building You A Better Online Business
> <><><><><><><><><><><><><><><><><><><><><><><><>
>
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
