12 messages in com.mysql.lists.perlRe: Accessing MySQL on another machin...
FromSent OnAttachments
Hal Vaughan25 Mar 2003 21:35 
Todd Finney25 Mar 2003 21:42 
Hal Vaughan25 Mar 2003 23:54 
Jochen Wiedmann26 Mar 2003 00:42 
Hal Vaughan26 Mar 2003 01:45 
Christopher Hicks26 Mar 2003 08:30 
Hal Vaughan26 Mar 2003 09:15 
Ulrich Borchers26 Mar 2003 10:03 
Hal Vaughan26 Mar 2003 12:07 
Ulrich Borchers26 Mar 2003 13:37 
Hal Vaughan26 Mar 2003 13:55 
Hal Vaughan26 Mar 2003 23:22 
Subject:Re: Accessing MySQL on another machine w/ DBI.pm
From:Hal Vaughan (ha@thresholddigital.com)
Date:03/26/2003 01:45:33 AM
List:com.mysql.lists.perl

On Wednesday 26 March 2003 03:42 am, Jochen Wiedmann wrote:

Quoting Hal Vaughan <ha@thresholddigital.com>:

'192.168.1.11' is not allowed to connect to this MySQL server at ./test.pl line 13

This is not a driver issue. You can easily verify that by using

mysql --host=mysqlhost --user=hal MailingList

It should bring the same error message. Check the host settings in the tables "db" and "user".

I've added TWO entries in "host", "db", and "user", in each one it gives me (under my user name -- "hal") full permissions from the host I'm on, both by system name and by system IP address. I would think that should give me all the permission I need. I even re-started MySQL afterward (I noticed the first time I added myself as a user to those tables I had to restart for it to take effect).

In "host" I've added the system, under IP addy and system name, with "hal" as the user and ALL priveledges enabled. I've done the same in "user", without specifying a password (once I get it working, I'll deal with that), and I've done the same in "db" to give full permission to use this one database.

Is there something else I can do or need to change/set?

(I'm using the latest 4.0.x that was just marked stable.)

Thanks!

Hal