Re: mysql_connect remote machine

Tom [tom.mathews@st.com] wrote: > 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. By "tried creating a username", do you mean that you tried to create a username *in MySQL*? Because that's what you need to do, and you'll need to GRANT that user privileges to the database/tables in question. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com > > 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. > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net