Using MySQL

What is MySQL

MySQL is an open-source relational database management system that uses Structured Query Language (SQL), the most popular language for adding, accessing, and processing data in a database.
MySQL is most commonly used as a Web application alternative to proprietary database systems because of its speed and reliability. MySQL can run on UNIX, Windows and Macintosh operating systems.

For more information on how to use databases and other advanced Web developing tools, please visit HTMLGoodies.com

Connect to a MySQL database using a language of your choice

To connect your web page to your MySQL database:

1. Log into your hosting control panel, and navigate to MySQL manager
2. In the left pane, select the database to which you wish to connect
   
3. In the right pane, select the username through which you wish to connect to your database
   
4. Click the Generate Code icon for the selected username. The Generate Code dialog is displayed.
   
5. In the Generate Code dialog, select the language for which you wish to create the connection string - Perl, PHP, Python or ASP (Windows hosting only)
   
6. As soon as you make your selection, the code window appears. It contains the connection string and other code necessary to connect to your database.
7. Select all the code in the window and Ctrl-C to copy it
8. Ctrl-V to paste this code into the appropriate place on your site, where you wish to connect to the database
   1. Search for *password* in the code
      
   2. Replace with the actual database password
      
      Note: All other parameters have been entered into the code for you. However, for security reasons, %%CorporateShort%% cannot access nor display your database password