Freeola Home Get Dotted Domains Win Free Games Freeola Blog Freeola Guides Customer Forums

Freeola Guides


MySQL Information

By Freeola Support on 18th December, 2017 | 1 Comment(s) | 1 out of 2 people found this article useful.

Welcome to the Freeola Internet customer support pages. This guide is designed to give some general information about MySQL Databases. For more internet help topics please visit our main Support Page.

 

MySQL is a database system which allows you to build extra functionality into your web site. MySQL is extremely powerful, very fast and flexible for a wide-variety of needs. Although only recommended for customers with some experience of online database applications, it is relatively easy to pick up.

 

Freeola currently offers MySQL database functionality into two separate forms: Freedom MySQL is available to customers using our free web hosting services, connecting with a Freeola Broadband or Dial-Up Internet connection. VIP MySQL should be used in conjunction with one of our VIP Hosting products.

 

This page provides some basic instructions on how to connect to your Freeola MySQL database and how to administer it using PHPMyAdmin. For the differences found within VIP SQL please scroll down the page or click here.

 

Freedom MySQL

 

Basic Connection Information

 

This information is for customers connecting to their Freedom MySQL database from a PHP script using mysql_connect

 

Server Address: http://mysql.freeola.net
Database Name: Your MySQL User Name (e.g. sr0123456)
Database Password: Your MySQL Password

 

With MySQL, Freeola also provides you with PHP MyAdmin which is a professional quality utility used for administering your MySQL database. Below you will find basic instructions on how to use PHP MyAdmin.

 

Using PHPMyAdmin

 

  1. Connecting to your database
    The web admin address for your MySQL database is http://mysql.freeola.net. You can connect to your database by logging in to MyFreeola and clicking on the MYSQL DATABASE link or by simply entering http://mysql.freeola.net into your browser, you will then be prompted to enter your Freeola User Name (e.g. sr0123456) and your Freeola Password.

  2. Creating a table
    To create a table in your database, click on your Freeola User Name in the left hand column. Your Freeola User Name (a seven-digit number that begins with the letters 'sr') is the name of your database. You will first need to give your table a name and define the number of fields the table is to contain. Enter this information in the appropriate fields under the Create new table on database: heading in the right hand column. Click the Go button.

  3. Setting the field attributes
    In this section you will need to give each field a name, a type and set the maximum character length. Click the Save button. Further information on how to set the field attributes can be found via the Documentation link.

  4. Entering data
    You will now find the table you just created located under your Freeola User Name in the left hand column. To add data to your table, click on the Insert tab and enter the data in the appropriate fields. To browse the information in your table, click on the Browse tab.

  5. Edit or Delete data
    You can edit or delete any data in your database by browsing the contents of a table and clicking on either the Edit or Delete link located to the left of each record.

  6. Deleting a table
    To delete a table in your database, select the table from the left hand column and then click the Drop tab. This will remove the selected table from the database.

Further information on how to use PHPMyAdmin can be found via the documentation link provided within the program.

 

Using MySQL-Front

 

  1. Open MySQL-Front.

  2. You will need to enter the following information into the MySQL-Front login box:
    Hostname / IP: mysql.freeola.net
    Username: Your MySQL User Name (e.g. sr0123456)
    Password: Your MySQL Password

  3. To create or delete a table, click on Tools from the menu bar or the appropriate button on the tool bar.

VIP MySQL

 

Customers currently using our VIP Hosting services can add SQL functionality to their hosting package from the Optional SQL link within their MyFreeola account.

 

Basic Connection Information

 

This information is for customers connecting to their VIP MySQL database from a PHP script using mysql_connect or any other Content Management System loaded onto their FTP space.

 

Database Server: localhost
Database Name: The name you have given to the relevant database
Database Username: The name you have given to the relevant database
Database Password: The password you assigned to the database

 

As with the Freedom SQL service if you do not have a note of this information you are able to view all of these settings from within the VIP Web Hosting link within your MyFreeola account.

 

Using PHPMyAdmin with VIP SQL

 

In order to utilise the PHPMyAdmin utility on the VIP SQL server you will be required to visit http://www.yourdomain.com/vipsqladmin/ (where yourdomain.com is your web address). The username and password required are the Database Username and Database Password set when the database was created. If you do not have a note of this information you are able to view these settings from within the VIP Web Hosting link within your MyFreeola account.

 

External Connections with VIP SQL

 

Please note: Third party clients, such as MySQL Front, will not work with the VIP SQL service as all external connections to this server are prohibited.


Did you find this article helpful?

Yes | No


Article Comments (1)
Add your comment:

Comments are limited to 750 characters, you have 750 remaining.


Avatar
Erik Pattison commented on 21st April, 2012:
Thanks - this was really clear
Intuitively helpful!
I don't know if many people bother to do this, but I wanted to thank Freeola and Get Dotted for the fantastic services. I ha...
Just a quick note to say thanks for a very good service ... in fact excellent service..
I am very happy with your customer service and speed and quality of my broadband connection .. keep up the good work . and ...
Matthew Bradley
Superb in every way...
I have just changed from one ISP to Freeola Broadband and can only say that this is the best thing that I could ever have do...
Peter Everett

View More Testimonials

Need some help? Give us a call on 01376 55 60 60

Go to Support Centre
Tell us what you think!

Live Chat is offline

Live Chat is available:
9am to 6:30pm Monday to Friday (excluding bank holidays).

01376 55 60 60

Send us a ticket.

It appears you are using an old browser, as such, some parts of the Freeola and Getdotted site will not work as intended. Using the latest version of your browser, or another browser such as Google Chrome, Mozilla Firefox, or Opera will provide a better, safer browsing experience for you.