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 e

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 w

RE: remote database access in perl

2004-12-13 Thread Graeme St. Clair
As someone else said, this is almost certainly a MySQL "problem". When you connect from a local machine, you are known to MySQL as 'fred'@'localhost', and you have a particular identity. When you connect from a remote m/c, you are 'fred'@'some.tcp.ip.addr', and you have a totally different identi

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 se