Connecting Mysql Database on remote server
 

hi all,


How do i connect to mysql database on remote server. I have installed mysql database on one server
ip- 192.9.200.110 . now from other server ip 192.9.200.108 i want to connect to mysql database on
first server using PHP. i have written connect.php and given the ip of mysql server but while connecting i got the error -

Warning: Host '192.9.200.108' is not allowed to connect to this MySQL server in /home/kiosk/connect.php on line 7

Warning: MySQL Connection Failed: Host '192.9.200.108' is not allowed to connect to this MySQL server in /home/kiosk/connect.php on line 7

Warning: Supplied argument is not a valid MySQL-Link resource in /home/kiosk/connect.php on line 8


what could be the problem .... please help ../.

thanx in advance


akamol

Have you added the remote host to the mysql user table?

hello dkloes ,

no i have not added remote host in mysql user table ...but how do i add it and after adding
how do i connect to mysql. ....do reply

thanx


akamol

AFAIK default install of MySQL does not permit remote access. Try this out -
GRANT privilege_list | * on 'mysql_user_name'@'192.9.200.108' identified by 'some_password'

| delineates *either* a list_of_privileges and *=ALL. Check out the GRANT syntax in the MySQL manual.

regards
akr