Get MySQL, PHP and phpMyAdmin on your own domain
Having your domain hosted at One.com lets you use PHP and a MySQL database. Moreover you can easily manage your database through phpMyAdmin. One.com's Linux servers are the ideal place to host your database-supported websites if you require reliability, stability and performance at a competitive price.
A web space at One.com provides access to, among other things, the following elements:
MySQL - a relational database
A database is a way in which to store information, which ensures that the information can be quickly retrieved and used where it is needed. Unlike information that is written on, e.g. a piece of paper or typed into a text file, a database saves the information in tables so each individual entry can be quickly retrieved in a systematic and precise way.
A database comprises one or more database tables, each of which contains a number of cells that are divided into columns and horizontal rows, much like in the same way as a spreadsheet. A database table is also called a relation, the rows are called the table's body and MySQL is a so-called relational database.
MySQL at One.com
One MySQL database is always part of the web space package at One.com. The MySQL database is designed so that it can be easily used by many different applications at the same time. For example, this means that you can use a CMS (Content Management System), a blog or an open source, PHP-based gallery simultaneously on one and the same web space.
A MySQL database is typically used together with a website. SQL (Structured Query Language) is the database language that is used to communicate with the database. Moreover, it is also the most popular existing database language. A MySQL database is a well-tested, high-performing and secure way in which to store information.
PHP and MySQL - a strong duo
The web programming language, PHP, and the database language, SQL, are a pair of powerful and versatile tools, which when combined seriously show their strength.
The content of a website, which is programmed with PHP, will typically be stored in a MySQL database. The database will be attached to the web space and domain where the website is located and together, PHP and MySQL will be able to run an almost endlessly large selection of scripts and web applications that are made freely available on the Internet.
Read more: MySQLtutorial.org is a good place to find tips to get going with MySQL
Many possibilities with MySQL
MySQL is open source and this means that the program can be used for free. Besides the fact that the costs of MySQL hosting can generally be kept at a relatively low level, it also has the advantage that it is well-documented with good possibilities of finding help online if, as a user, you need help to solve a problem or just need creative inspiration.
Read more: MySQL.com - The official website for MySQL
CMS the easy way
Some of the most popular application possibilities for MySQL databases is the so-called "Content Management Systems", which are normally just called a CMS.
A CMS is a publication system with a graphic user interface that makes it possible to publish and manage large volumes of content on a website. A CMS often uses a MySQL database but without you needing to program or work directly in the website source code, much less write enquiries to the database. In so doing, the content of all publications can have a professional result.
At One.com you can, for example, use TYP0 3, CMS Made Simple or Joomla CMS. A blog system is fundamentally also a CMS and stores the content of the blog posts and comments in the MySQL database.
To begin using CMS you simply download the installation files from the provider's website and upload them to your web space via FTP. There are differences to the procedures with the various CMS systems, but you typically enter your database username and password in a configuration file, after which you can begin placing content on your website. It is easy to get working with CMS.
Read more: 1-click WordPress is an easy way to get WordPress installed on your web space with One.com.
PhpMyAdmin and MySQL
Great abilities are rarely needed to manage a database-supported website when based on MySQL and PHP. One.com makes the open source administration tool, phpMyAdmin, available to all clients and the program's intuitive, graphic interface makes it easy to manage the web space's database. For example, in phpMyAdmin you can export individual tables or make a backup copy of the entire database.
While installing a gallery, a discussion board or a CMS, you normally do not need to access the database directly. The setup and creation of tables and the like is all automated. But phpMyAdmin is also a possibility that can prove useful in some circumstances. Due to performance reasons, it can well be an advantage to limit the size of a database, but there are no separate upper limits to the size of a database at One.com. The extent is only determined by the size of the web space and if you experience problems with space, it is easy to upgrade to a larger web space.
Read more: You can read more about phpMyAdmin here.