Connecting to remote MYSQL server

[krappleby025]

Hi all,

im trying to connect to a remote mysql server on someone elses computer. with there permission of course.. and i am using the following to allocate the ip

$host="***.***.***.***";

note the *** are actually the ip but i have removed them

when it try to run the script i get

Warning: Host '***.***.***.***' is not allowed to connect to this MySQL server in /home/httpd/vhosts/kra-computers.com/httpdocs/test_sites/linkadmin/includes/dbconnect2.php on line 6

any ideas

cheers

 

[nego78]

probably your user cannot connect from this location

what does he have privileges ?

Webdesign

 

[krappleby025]

If i place localhost in the $host then it works on my server.. but on someone elses server with the ip address it will not work..

any ideas

 

[Olavxxx]

krappleby025:
Ask the other hosting company which permissions they gave for the db-user you are trying to connect with.

eg. there might be some ip-specific settings.

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster

 

[krappleby025]

it is my own server..
there are only two avilalbe ip addresses on the server.. so one of htem must be for the MYSQL database,

one is for the websites, and the other is a dns...

 

[ingresman]

Try on the remote machine a line like:

GRANT ALL PRIVILEGES ON test.* TO 'root'@'xx.xx.xx.xx'

and see if you can get to the tables from the root user ot the user you habe php running in (in which case change the root to whatever.