MySQL: Help and advice Below is some useful information for using the optional MySQL service with Freeola's hosting services. MySQL is an chargeable optional service that we provide for users to use with their Freeola Webspace. It can be enabled by logging into your MyFreeola account and within the Webspace section clicking on the Optional MySQL Database link. MySQL is the most commonly used database system used with PHP, and is widely used for forum, content management systems (CMS), guestbooks and shopping trolleys. Once you have arranged for MySQL to be setup for you, you will be assigned a new account number and password. The account number assigned will also be the name assigned to your database. Provided here is a runthrough of setting up a common content management system called Joomla. The first thing you will have to do to install this package is to download the file and decompress it. Most website scripts will be supplied in .tar.gz format, this is similar to a ZIP format and can be extracted using Winzip or Winrar. You will then need to upload the website using an FTP client, we usually recommend that customers use Filezilla as it is friendly and free to use. If you want the software you are installing to be your default website then you can upload the website into the root of your htdocs folder, but if you just want to evaluate the software then we would recommend uploading the website into a subfolder and running it from there. Once the files have been uploaded it will be time to start the next stage of the installation procedure which is done via your web browser.  You will need to visit your website address (ie http://www.mydomain.com) and if you have installed the website in a subfolder add the subfolder on the end of the url (ie http://www.mydomain.com/joomla) You will see an image similar to the one below appear click the Next >> button A license agreement will be shown which you will be deemed to have accepted when you click the Next >> button. A webpage similar to the one below will appear asking you to fill some details in. The details you will need are as follows, the Host Name which will be mysql.freeola.net. The MySQL User Name, this will be the number in the form sr0XXXXXX to which your MySQL has been assigned. The MySQL Password, this will be the corresponding password to the account. The MySQL Database Name, this will be the same number that you used for the MySQL User Name You can safely ignore the MySQL Table Prefix unless you are running multiple Joomla sites using the same MySQL username. Click on Next >> and you will be asked to give a name for the Website, this can be anything. Click on Next >> again when you have finished and you will be asked to confirm URL admin e-mail and file directory chmods. You should not need to change anything other than to add in your E-mail address and either change or make a note of the Admin password. Click on Next >> again , you will be reminded of your username and password and asked to remove the installation directory, this can be done by connecting via FTP and deleting the folder installation from within the folder you have installed Joomla into. You can now log into your Administrator account using the link on the page to start managing your website.