Using MySQL

MySQL is the world's most popular open-source database server on the World Wide Web. It is commonly used with the PHP scripting language, another very popular open-source application.

Through the SQL Administration area of the Control Panel, you are able to import existing MySQL databases and create new ones, as well as set up a DSN (data source name) to access your database. The data source name will be the main avenue for communicating with our MySQL server when using a scripting language such as PHP.

When you create a MySQL database, you'll be able to choose from two different versions of MySQL: 5.5, and 5.6. Our MySQL servers run with InnoDB support on Linux-based machines. Direct access to these machines is not provided, but you can connect to the servers using a MySQL client. We recommend using MySQL Query Browser, found at http://www.mysql.com/products/tools/query-browser/

To connect to a MySQL database from a Web page, you must use a scripting language such as PHP. In your scripts, you will need to use a DSN or DSN-less connection string. A DSN connection string requires you to set up a DSN in the SQL Administration area. Once there, click on the "View Sample Connection String" link for a number of sample connection strings.

ColdFusion DSNs

All system data source names (DSNs) added through the DSN Administration or SQL Administration sections of your Control Panel are automatically set up as Windows system DSNs. Once you have added a DSN to your Control Panel it will take about 10 minutes before your DSN will be available for use with your ColdFusion code.

Note: When adding a SQL DSN you must remember that the username and password are not stored in the ColdFusion Administrator. Therefore you will need to supply the database username and password in your DSN connection string.

More information on MySQL can be found at their official site, http://www.mysql.com.

Need PHPMYADMIN

If you require phpmyadmin to manage your MySQL database, in the Scripts section of the control panel there is a step by step wizard to install it on your domain. You will need to add the database you have created to the phpmyadmin you create. You can add multiple MySQL databases you have to one instance of phpmyadmin.

Was this answer helpful?

 Print this Article

Also Read

Securing Your Site Using SSL

Secure Sockets Layer (SSL) is the standard for data encryption on the World Wide Web, allowing...

Setting up a permanent 301 redirect via .htaccess

A permanent 301 redirect in your .htaccess file lets search engines and others know that an old...

Pointing your domain to your shared hosting account.

If your domain name is registered and owned by you but does not currently point to the LFC...

Accessing Your Detailed Web Site Access Statistics

LFC Hosting offers nightly Web site statistical traffic analysis for all of your domain names....

I would like to make a Wildcard Subdomain

Wildcard subdomains let URLs like anything.yourdomain.com bring up the same Web site. Although...