FUDforum: PHP discussions » remote connection to mysql from php

Home » General » PHP discussions » remote connection to mysql from php

Show: Today's Messages :: Polls :: Message Navigator

remote connection to mysql from php [message #32075]

Wed, 07 June 2006 09:48

betty

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.

Report message to a moderator