LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   Connecting Mysql Database on remote server (http://www.linuxquestions.org/questions/programming-9/connecting-mysql-database-on-remote-server-104166/)

akamol 10-15-2003 06:13 AM

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

dkloes 10-15-2003 07:37 AM

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

akamol 10-16-2003 12:19 AM

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

dkloes 10-16-2003 04:24 AM

http://www.devshed.com/Server_Side/MySQL/Administration

then 10-16-2003 11:46 AM

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


All times are GMT -5. The time now is 04:16 AM.