What is a MySQL Database?

A MySQL database is a web hosting database that is used to store web site information like blog posts or user information. A MySQL database is the most popular type of relational database on the web today. This is partly because it is completely free but also very powerful.
What is a MySQL database capable of?

In basic terms, a MySQL database is capable of storing any type of that you want. It will let you quickly store and retrieve information and multiple web site visitors can use it at one time. You will use SQL statements to accomplish all of this. In more technical terms, MySQL 5.0 has the following features:

    A broad subset of ANSI SQL 99, as well as extensions
    Cross-platform support
    Stored procedures
    Triggers
    Cursors
    Updatable Views
    True VARCHAR support
    INFORMATION_SCHEMA
    Strict mode
    X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine
    Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, MySQL Archive for storing historical data in little space)
    Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB
    SSL support
    Query caching
    Sub-SELECTs (i.e. nested SELECTs)
    Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
    Full-text indexing and searching using MyISAM engine
    Embedded database library
    Partial Unicode support (UTF-8 sequences longer than 3 bytes are not supported; UCS-2 encoded strings are also limited to the BMP)
    ACID compliance using the InnoDB, BDB and Cluster engines
    Shared-nothing clustering through MySQL Cluster

What is a MySQL database used for?

MySQL is the database of choice for several different web programming languages including PHP, Ruby on Rails, and Python. These programming languages make is extremely easy to connect to a MySQL database. It is also used for many popular content management scripts like Joomla!, Drupal, WordPress and WikiMedia.

Was this answer helpful?

 Print this Article

Also Read

What is cPanel?

cPanel is web hosting control panel software that lets you quickly manage your web site and...

What is Shared Web Hosting?

In a nutshell (think pistachio), shared web hosting is a service that lets you host your websites...

What is Dedicated Web Hosting?

Dedicated web hosting is hosting where you get your very own server dedicated to do your bidding...

Windows vs Linux Hosting

Web hosting systems are as varied as genders. There are basically only two kinds with a few of...

What is VPS Hosting?

Basically, VPS hosting (Virtual Private Server hosting) is a service that gives you a web...

Powered by WHMCompleteSolution