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]
