What is a MySQL Database?

Compare the Best MySQL Hosting

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

MySQL database Features

In basic terms, a MySQL database is capable of storing any type of data 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.

What is phpMyAdmin?

Databases can be difficult to manage using just individual SQL statements. It is much easier to manage a database using a graphical user interface (GUI). One of the best and most popular GUI’s for managing a MySQL database is called phpMyAdmin. It is a web-based application that makes it easy to manage your MySQL database. phpMyAdmin will let you add, remove and manage databases, tables, and entries; backup the database, run specific SQL queries, search and import record, and much more. Learn more about phpMyAdmin from its official website.

What is phpMyAdmin

Learn more about MySQL on its official website. They have comprehensive documentation and have forums and training. You should also check out the SQL tutorial on W3Schools and some articles in Sitepoint's PHP & MySQL section.

If you are looking for a web host that supports MySQL, look at our comparison of the best MySQL Hosting or try our web hosting wizard which will give you more search options.

© Host Shopper | Web Host Comparisons | All Rights Reserved