need to no about a setup of my >>mysql and php<< is it possable

[redarrow]

Advance thank you.

 

i have setup a webserver on it own, and a database mysql server on it own,

i need to no is it possable for me to get the web server to talk to the internal mysql server via it

own made up ip.

 

 

so if some one wanted to add somethink to the databse via the web server

and the web server passing it to the ip 192.168.0.10 is that possable cheers.

 

 

been on this all day i get the error websever not allowed to connect to ip 192.168.0.10 port 10036

dont no why.

 

so the database server got the ip off 192.168.0.10 but dosent work even setting the router to ip and same port fowarding.

 

 

[redarrow]

ok according to mysql you got to bind the mysql server to the root user

example

 

GRANT ALL PRIVILEGES ON *.* TO root@'192.168.0.1%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

 

http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

[redarrow]

 

your need this as well ok.

 

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'

    ->    IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

mysql --user=root mysql