Re: Wont connect to remote mysql

That's not it. The user can connect to the database using the mysql client on the same machine as the webserver to the database machine. Blake On 07/10/2003 12:03 AM, "Andy Green" <_agreen@bellsouth.net> wrote: > check the permissions granted to the user to make sure that it's not > restricted to localhost only. i had the same problem you're describing not > too long ago, and i discovered that the user name i was passing was > restricted to localhost only. > > the permissions can be viewed in the 'host' attributes, found in the 'user' > table in the 'mysql' database. > > hope this helps > > green > > -----Original Message----- > From: Blake Crosby [mailto:me@blakecrosby.com] > Sent: Monday, October 06, 2003 11:55 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Wont connect to remote mysql > > > Hello, > > For some reason php will not connect to a remote mysql server.. Using the > following code: > > <?php > $link = mysql_connect('hostname:3306', "username", "password") > or die("Could not connect: " . mysql_error() . "\n"); > > print ("Connected successfully"); > mysql_close($link); > ?> > > > Returns the following error: > > Warning: mysql_connect(): Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) in /vws/blakecrosby.com/docs/test.php on line 2 > Could not connect: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > > > I can connect to the database using the mysql client from the same machine. > Any suggestions? > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > >