RE: Access MYSQL database across Internet

It is possibly, but not always a good idea. 1.) Unless you're using v4.0+SSL all DB traffic is unencrypted 2.) Depending on how far the servers are physically apart DB I/O gets slow 3.) You open yourself up to security risks Both the host and the user must be added to the mysql.* tables. Read up on the GRANT command in the MySQL manual. --Joe -- Joe Stump <joe@joestump.net> http://www.joestump.net "Label makers are proof God wants Sys Admins to be happy." -----Original Message----- From: René Fournier [mailto:rene@smartslitters.com] Sent: Tuesday, April 29, 2003 9:34 PM To: mysql@lists.mysql.com; php Subject: Access MYSQL database across Internet Is this possible? I would guess so, since one would just change "localhost" to an IP address, right? $db = mysql_connect("127.0.0.1","user","pass"); But I imagine the ISP must allow this kind of access—and I imagine most don't... Does anyone know how this might be done? Basically, I want to be able to update tables residing in various databases (on various ISPs) from one set of PHP scripts (on one machine). But I need to connect to those databases somehow. If you know of an article or resource or anything, I would appreciate it. Thanks. ...Rene --- René Fournier, rene@smartslitters.com Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jstump@aa.acinc.com