Re: Connecting from PHP to MySQL on another Server

> 1. What is the difference between working with PHP and MySQL on a local > server and working with PHP and MySQL when MySQL is on a remote server None in terms of functionality. > 2. What is the protocol used to connect to MySQL on a local server and > what is the protocol used to connect to a remote MySQL server? On the local machine a client (PHP is a client) can connect through unix sockets or TCP (3306). On a remote machine its TCP only. Unix sockets access is faster than TCP. > 3. Is there a difference in performance between connecting from PHP to > MySQL on a remote server or PHP to MSSQL Server? See above answer. Also you have any TCP/IP overhead to add on. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 Mob 07763 620378 PGP Key available, send email with subject: Send PGP Key