mysql Database

JoshHendo · 09-16-2005, 01:26 AM

I want to connect to a database that is not on my server. What would I put insted of localhost, or what code should i put if it isn't the same as usual.

(For PHP)

dgaussin · 09-16-2005, 01:30 AM

Replace localhost with the database server IP address.

And you'll have to authorize remote connexion on the database server for your web server too...

JoshHendo · 09-16-2005, 01:36 AM

Quote:

Originally Posted by dgaussin

Replace localhost with the database server IP address.

And you'll have to authorize remote connexion on the database server for your web server too...

this is what i get when i put in the IP address

:

Parse error: parse error, unexpected T_DNUMBER in /home/xvsxpne/public_html/php/dn2/install/finish.php on line 21

dgaussin · 09-16-2005, 01:40 AM

It's a PHP syntax error you have here, not mysql related.
Did you quote the IP address ie. '127.0.0.1' ? Check your code syntax anyway.

stscac · 09-17-2005, 11:44 AM

You can also put the domain name instead of the ip address (since the domain just resolves to an IP address).

Let me know if you need anything else, Josh.

-Steve

09-16-2005, 01:26 AM	#1 (permalink)
JoshHendo Senior Member Join Date: Apr 2005 Location: Australia Posts: 1,099 48.40 NP$ (Donate)	mysql Database I want to connect to a database that is not on my server. What would I put insted of localhost, or what code should i put if it isn't the same as usual. (For PHP) __________________ :bingo: :kickass: :lala: :notme: :great: :gn:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
MySQL Database Tutorial - Adding a Username to a Database	Veolus	Webmaster Tutorials	7	08-26-2005 04:24 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

09-16-2005, 01:30 AM	#2 (permalink)
dgaussin Senior Member Join Date: May 2004 Location: France Posts: 1,294 85.60 NP$ (Donate)	Replace localhost with the database server IP address. And you'll have to authorize remote connexion on the database server for your web server too...

09-16-2005, 01:40 AM	#4 (permalink)
dgaussin Senior Member Join Date: May 2004 Location: France Posts: 1,294 85.60 NP$ (Donate)	It's a PHP syntax error you have here, not mysql related. Did you quote the IP address ie. '127.0.0.1' ? Check your code syntax anyway.

09-17-2005, 11:44 AM	#5 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,794 47.60 NP$ (Donate)	You can also put the domain name instead of the ip address (since the domain just resolves to an IP address). Let me know if you need anything else, Josh. -Steve

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)