Get flash to fully experience Pearltrees
MySQL 5 introduced a plethora of new features – stored procedures being one of the most significant. In this tutorial, we will focus on what they are, and how they can make your life easier. Introduction “ A stored routine is a set of SQL statements that can be stored in the server.” A stored procedure is a method to encapsulate repetitive tasks.
realprogrammers.com What follow is how to set up as SSH tunnel using PuTTY with the MySQL port (3306) forwarded as an example. After completing this how-to you'll have port 3306 on your local machine listening and forwarding to your remote server's localhost on port 3306. Thus effectively you can connect to the remote server's MySQL database as though it were running on your local box.
Notes 1. This is not an "anti-MySQL" list, although it does contain critical comments; 2. MySQL is continually improving and some of the points listed here are no longer valid for recent versions; 3. This list is regularly updated, but may not always reflect the latest developments (unfortunately I've been busy the past couple of months and haven't had time for the site at all; watch this space ;-). Note to Slashdot readers: this page deals with issues related to MySQL 4.1 and earlier, not 5.0 4. There's a list for PostgreSQL too. 5.