Latest LQ Deal: Linux Power User Bundle
Go Back > Forums > Non-*NIX Forums > Programming
User Name
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.


  Search this Thread
Old 10-15-2003, 07:13 AM   #1
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- . now from other server ip 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 '' is not allowed to connect to this MySQL server in /home/kiosk/connect.php on line 7

Warning: MySQL Connection Failed: Host '' 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

Old 10-15-2003, 08:37 AM   #2
Registered: Oct 2003
Posts: 66

Rep: Reputation: 15
Have you added the remote host to the mysql user table?
Old 10-16-2003, 01:19 AM   #3
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. reply


Old 10-16-2003, 12:46 PM   #5
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'@'' identified by 'some_password'

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



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 07:34 AM
probs with connecting to mysql database using php ankscorek Linux - Software 4 08-16-2005 08:40 PM
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 06:52 AM
MySQL and remote database inspleak Linux - Networking 3 09-17-2004 02:00 AM
connecting to remote MySQL server acos7 Linux - Software 2 01-31-2004 12:37 AM > Forums > Non-*NIX Forums > Programming

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

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