Re: Connecting to a remote database

further on you should tell your DBMS that not only local scripts (users), but also external users may access your database. this is done by modifying the table "db" in the database "mysql". with this table you can control which hosts may access your dbs. the simplest but also most risky way is to set host = % and db = %. db = "DB" and host = "your.remote.machine" (or for several domains or IP-ranges) would be safer already (the rest of the fields/permissions to be set per row are mostly self-explaining). HTH steff Matt Babineau wrote:

Try to access the SQL DB by IP Address. If you want to access it from outside you LAN, The machine the SQL DB is on has to have an external IP. Matt Babineau Freelance Internet Developer e: mbabineau@illuminatistudios.com p: 603.943.4237 w: http://www.illuminatistudios.com -----Original Message----- From: R.S. Herhuth [mailto:ronherhuth@pop.mindspring.com] Sent: Thursday, April 18, 2002 3:57 PM To: php-windows@lists.php.net Subject: [PHP-WIN] Connecting to a remote database Newbie alert! I am able to connect to a SQL Server Database on my local network by specifying the host as "testHost" the database is "DB". My question is if I'm outside the network what is the correct syntax that I need to call in the host in order to access the database? Thanks, ROn