Home » Hosting Encyclopedia » Hosting Terms » Database » MySQL

MySQL

MySQL is the most widely used open-source database management system (software that enables the development and management of databases) that enables the creation of multiple databases that can be accessed by many users simultaneously. MySQL is used for the management of relational databases that are most commonly used for the storage of great amounts of all types of data. Relations are typically presented as tables with columns and rows. For the use of relational databases, indexes could be created that simplify and speed up access to the information. MySQL is deployed by various large and demanding websites including popular sites like Facebook, Wikipedia, Twitter, Flickr and so on. MySQL has a few versions – one free and a couple of paid ones that offer additional functionalities.

 

MySQL Usage

MySQL is part of the LAMP software package often used for the development of web servers. MySQL databases are used by various CMSs and popular web programs like WordPress, Joomla, Drupal, phpBB, TYPO3 and many other applications built on the LAMP software stack. The wide use of MySQL is also due to the fact that it is user-friendly and very flexible: available for about 30 computing platforms including Linux, Microsoft Windows, Mac OS X, AIX, Solaris, Symbian, etc.

For the management of MySQL, there are various graphical applications that can be used for simple user-friendly creation and manipulation of databases, most popular of which is phpMyAdmin – also free web-based application offered by most hosts worldwide.

Was this article useful?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Newest Articles:

KVM

What you need to know: KVM (Kernel-based Virtual Machine) is a virtualization technology that is free, open-source, and available in most modern Linux distributions. Thanks to it, you can create and run Linux and Windows-based virtual machines that are independent of...

Second Level Domain (SLD)

The Second Level Domain or SLD is essential to the hierarchical Domain Name System. It is the second part of the full domain name after the Top Level Domain, on its left side. The Second Level Domain is often the same as the website name, the company, or the...

Top-Level Domain (TLD)

The Top Level Domain name (TLD) is the last or right-most fragment of the domain name. The parts of the domain name are separated with dots and form their own hierarchy in the Domain Name System (DNS). There is a Top-Leveл Domain list where you can see all available...

IANA

What is IANA? Although the Internet is not really a centralized system, there are some key infrastructure elements that need to be coordinated. The Internet Assigned Numbers Authority (IANA) is an organization that was founded in 1988 by the government of the U.S.A....

ICANN

What is ICANN? ICANN is an abbreviation from Internet Corporation for Assigned Names and Numbers. It is the non-profit organization that’s responsible for the assignment and coordination of unique Internet addresses and names for all devices connected to the Internet,...

Ready to Create Your Website?