RE: [PHP] Urgent Help needed

Or 203.199.% or even 203.199.234.% so you don't open it up to the whole world. ---John Holmes... > -----Original Message----- > From: Patrick Weightman [mailto:PatrickWeightman@hsoft.co.uk] > Sent: Friday, October 18, 2002 5:18 AM > To: John Nichel; manuvi@eth.net > Cc: php-general@lists.php.net; lngs@vsnl.com > Subject: RE: [PHP] Urgent Help needed > > You need to set the host for the user in MySQL to % in order to connect > remotely > > Patrick Weightman > http://www.hsoft.co.uk/ > > -----Original Message----- > From: John Nichel [mailto:jnichel@by-tor.com] > Sent: 18 October 2002 10:17 > To: manuvi@eth.net > Cc: php-general@lists.php.net; lngs@vsnl.com > Subject: Re: [PHP] Urgent Help needed > > > This doesn't sound like a php problem to me, more like something with > MySQL. The fact that you're getting the MySQL error message says that > you're script is contacting the DB. Telnet into the remote machine, and > see if you can connect to the DB locally. If you can, check the user > table in the mysql db, and see if the user you are trying to connect as > has permission to connect remotely. > > manuvi@eth.net wrote: > > Hi all, > > > > > > I have used the following script to connect our remote database from my > local > > machine. The PHP script is at my local machine. > > > > When I tried to connect the database, instead of connecting to the IP > provided > > in the script, it is searching the Dynamic IP of my Internet Service > Provider. > > and getting the following error. > > > > > > Script in my local machine is : > > > > <?php > > mysql_connect("216.180.237.200","let_rot","vindb") > > or die ("cannot connect to mysqld"); > > mysql_select_db("lnet_bbay") > > or die("cannot select database"); > > ?> > > > > The IP 216.180.237.200 is the IP provided by my Web space provider. > > > > The error message is, > > > > Warning: Access denied for user: 'lngsnet_root@203.199.234.139' > > (Using password: YES) in c:\apache\htdocs\depots\temp\bomy\connect.php > on line > > 2 > > > > Warning: MySQL Connection Failed: Access denied for > user:'lngsnet_root@203.199.234.139' > > (Using password: YES) inc:\apache\htdocs\depots\temp\bombay\connect.php > on line > > 2 > > cannot connect to mysqld > > > > > > The IP 203.100.234.139 is the Dynamic IP of my Internet Service > Provider. > > > > Please help me to sort out the problem. > > > > Regards, > > > > Vinod. > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php