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.
  2. On the upper pane, click HOSTING.
    Hosting Dashboard
  3. On the left sidebar, click MySQL Management. 
    MySQL Management
  4. Under MySQL Databases, look for the Database you wish to connect, then click Manage. 
    Manage
  5. Look for the Database User you wish to connect your database to, then click the three-dotted icons on its far right.
    three-dotted icon
  6.  Click Generate Code from the drop-down menu. 
    three-dotted icon

 

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) 
Select the language
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, we cannot access nor display your database password.

  1. 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 
       
      Locate the password in the code
    • 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