note 27029 added to ref.mysql

If you have a Windows machine running a webserver with PHP you don't need to install MySQL server to locally test scripts, if you are granted to establish a Secure Telnet connection (port 22) to the remote webserver. To do this you need a Secure Telnet client, which supports port-forwarding. Before you establish a connection, define the port-forward. Forward local port 3306 to [name or ip of remote server]:3306 Make sure that local ports accept connections from other hosts Save this session Connect to remote server with username and password Minimize the shell and that's it... You can use the same username (and password) as if you were working on the remote server ! E.g. : $link = mysql_connect("localhost", "root", "") or die("no way jose"); You may get a shell-timeout after xx minutes depending on your remote server, just reconnect or press enter in the shell once in a while... An example of a superb freeware Secure Telnet client is Putty : Putty : http://www.chiark.greenend.org.uk/~sgtatham/putty/ This 'discovery' really has saved me a lot of time because I don't have to upload the scripts to the remote server time and time again, pressing [save] is enough, heh (-: -- http://www.php.net/manual/en/ref.mysql.php http://master.php.net/manage/user-notes.php?action=edit+27029 http://master.php.net/manage/user-notes.php?action=delete+27029 http://master.php.net/manage/user-notes.php?action=reject+27029