Re: mysql_connect remote machine

From: Date: Tue, 28 Nov 2000 17:13:47 +0000
Subject: Re: mysql_connect remote machine
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-27624@lists.php.net to get a copy of this message
I'd come to the same conclusion myself. The problem which I have is that the server running the php script appends @itsdomain.com to the user name which I pass. I've tried creating a username that looks like username@itsdomain.com on the mysql server but this doesn't seem to work (there are no errors reported by MySQL, I just get the same error message as before. Any ideas? Thanks Tom jason@jnj.org wrote: > On Tue, Nov 28, 2000 at 02:30:52PM +0000, Tom wrote: > > I'm trying to connect to a mysql server on a remote machine using PHP 3. > > (The application is talking back from a SSL site to the main site to > > pull data out of the main database). > > > > uhh... I'm not sure what all this ssl/http stuff is about, but it shouldn't > matter. Mysql will be sitting there listening on the mysql port on a > specific IP. It doesn't care about the web protocols. > Just do: > > mysql_connect (mysqlhost,username,password); > > where mysqlhost is an IP number or hostname like db.yourdomain.com, > and assuming the database allows 'username' to connect with 'password', > you're in. > > The errors in your email give me the impression you just don't have permission > to connect to the database with that username/password combo.

« previous php.general (#27624) next »