Re: remote database access in perl

2004-12-14 Thread Adam Saeed
Thanks It works now. On Mon, 13 Dec 2004 23:43:06 -0800, Todd Lewis [EMAIL PROTECTED] wrote: usually you have to log in as a local user before executing your script. I have written a simple program that should get data from a remote database, but it is not working giving error:

remote database access in perl

2004-12-13 Thread Adam Saeed
I have written a simple program that should get data from a remote database, but it is not working giving error: DBI-connect(sugs:192.168.14.2) failed: Host 'www.sample.com' is not allowed to connect to this MySQL server at testbug.pl line 12 code is below: * #! /usr/bin/perl -w

Re: remote database access in perl

2004-12-13 Thread Tor Hildrum
On Mon, 13 Dec 2004 17:55:12 +0500, Adam Saeed [EMAIL PROTECTED] wrote: I have written a simple program that should get data from a remote database, but it is not working giving error: DBI-connect(sugs:192.168.14.2) failed: Host 'www.sample.com' is not allowed to connect to this MySQL server

Re: remote database access in perl

2004-12-13 Thread JD Durick
You might want to try this on your mysql server, might be a grant permission issue. 1. GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY PASSWORD; 2. FLUSH PRIVILEGES; 3. exit. Tor Hildrum wrote: On Mon, 13 Dec 2004 17:55:12 +0500, Adam Saeed [EMAIL PROTECTED] wrote: I have

RE: remote database access in perl

2004-12-13 Thread Graeme St. Clair
identity. You almost certainly need to get your MySQL administrator to allow the remote identity to connect. Rgds, GStC. -Original Message- From: Adam Saeed [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 7:55 AM To: Perl Beginners List Subject: remote database access in perl I have