FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » PHP discussions » remote connection to mysql from php
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
remote connection to mysql from php [message #32075] Wed, 07 June 2006 09:48 Go to next message
betty is currently offline  betty   United Kingdom
Messages: 2
Registered: June 2006
Karma: 0
Junior Member
Hello I wonder , if you can help, I've read Mysql manual but i must be missing something because,i still can't connect to my remote mysql database.. So far i've added the code below on my php page:
mysql_connect($remoteserver,$username,$password);
where $remoteserver is the ipaddress and port number.
error message: Host is not allowed to connect to this MySQL server.

i have read that i have to make sure skip-networking is commented (or remove line) and add following line
bind-address=YOUR-SERVER-IP.But to which file, i can't find the line in my.cnf file. I've MySQLServer5.0 installed,

I have also granted all privileges on "." to root@localhost on the remote server.
Please help.
Re: remote connection to mysql from php [message #32085 is a reply to message #32075] Wed, 07 June 2006 14:47 Go to previous messageGo to next message
Ernesto is currently offline  Ernesto   Sweden
Messages: 413
Registered: August 2005
Karma: 0
Senior Member
But when you connect remotelly you will not be root@localhost, you will be user@remotehost

Re: remote connection to mysql from php [message #32086 is a reply to message #32085] Wed, 07 June 2006 15:35 Go to previous message
betty is currently offline  betty   United Kingdom
Messages: 2
Registered: June 2006
Karma: 0
Junior Member
Thanks for your reply , it works now.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Slash problem
Next Topic: GPix Pixel Script - Spanish Translator .....
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Mar 29 11:54:11 GMT 2024

Total time taken to generate the page: 0.02875 seconds