LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 10-15-2003, 06:13 AM   #1
akamol
LQ Newbie
 
Registered: Jul 2003
Location: India
Posts: 12

Rep: Reputation: 0
Angry 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
 
Old 10-15-2003, 07:37 AM   #2
dkloes
Member
 
Registered: Oct 2003
Posts: 66

Rep: Reputation: 15
Have you added the remote host to the mysql user table?
 
Old 10-16-2003, 12:19 AM   #3
akamol
LQ Newbie
 
Registered: Jul 2003
Location: India
Posts: 12

Original Poster
Rep: Reputation: 0
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
 
Old 10-16-2003, 11:46 AM   #5
then
Member
 
Registered: Oct 2002
Location: FDR India
Distribution: RH9, Knoppix, MEPIS
Posts: 65

Rep: Reputation: 15
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting to a MySQL database hsa Linux - General 3 09-16-2005 06:34 AM
probs with connecting to mysql database using php ankscorek Linux - Software 4 08-16-2005 07:40 PM
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 05:52 AM
MySQL and remote database inspleak Linux - Networking 3 09-17-2004 01:00 AM
connecting to remote MySQL server acos7 Linux - Software 2 01-30-2004 11:37 PM


All times are GMT -5. The time now is 08:39 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration