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