1. Knowledge Base
  2. >
  3. Results
  4. >
  5. Article

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.
 
  • On the upper pane, click HOSTING. 

    User-added image
  • On the left sidebar, click MySQL Management. 

    User-added image
  • Under MySQL Databases, look for the Database you wish to connect, then click Manage. 

    User-added image
  • Look for the Database User you wish to connect your database to, then click the three-dotted icons on its far right.

    User-added image
  •  Click Generate Code from the drop-down menu. 

    User-added image
 
  • 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) 
    User-added image
  • 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.
 
  • Select all the code in the window and Ctrl-C to copy it
 


Note: All other parameters have been entered into the code for you. However, for security reasons, %%CorporateShort%% cannot access nor display your database password.

  • Ctrl-V to paste this code into the appropriate place on your site, where you wish to connect to the database
    • Search for *password* in the code 

      User-added image
    • Replace with the actual database password

yieldmanager

Thanks for visiting! Since you landed on this page of our website, we wanted to let you know you visited one of our paid endorsers while researching your purchase. close