MySQL | Open Source Relational Database Management System

MySQL Free Database Management System

Popular Open Source Relational Database Management System

Organize, access and manage large amounts of data for your online and offline apps via MySQL. It is a secure, easy-to-use and fast database management system.

MySQL open source DBMS is used as the database for the development of web-based, desktop-based and mobile applications. It is suitable to use for small as well as for big and complex web applications. MySQL is a free and open source relational database management system and provides support for cross-platforms. Furthermore, it provides built-in replication support. It works with many languages including PHP, PERL, C, C++, JAVA, etc. MySQL works very quickly and works well even with large data sets. It is customizable, so it allows programmers to modify the MySQL software to fit their specific environments and requirements.

Most developers use MySQL relational database system with PHP, which is the most popular programming language for web applications. Good examples for PHP & MySQL-based web apps are WordPress, Joomla, and Drupal. MySQL is released under an open-source license, so you have nothing to pay to use it. It handles a large subset of the functionality of the most expensive and powerful database packages. Furthermore, it supports large databases, up to 50 million rows or more in a table and the default file size limit for a table is 4GB, which can be extended to 8 million TB.

System Requirements

Following are the requirements to install MySQL on Ubuntu 18.04

  • Ubuntu 18.04 server
  • Access to a command-line/terminal window
  • A non-root user with sudo permissions
  • A basic firewall

Features

  • Easy to use
  • Compatible to cross-platforms
  • Secure
  • Uses multi-layered server design with independent modules.
  • Free to Download
  • High Performance
  • Provides transactional as well as non-transactional storage engines.
  • High Flexibility
  • Platform Independent
  • Dual Password support
  • GUI support
  • Built-in replication support
  • Embedded database library
  • Handle large databases
  • Fast as well as reliable
  • Client/Server Architecture
  • JSON document validation
  • Supports multi-threading that makes it easily scalable
  • Compatible on many Operating Systems
  • Allows transactions to be rolled back
  • Open Source

Installation

Follow these steps to Install MySQL on Ubuntu 18.04:

  • To install MySQL, first update your local server’s package index by typing following command:
sudo apt update
  • Then install the MySQL default package using the following command:
sudo apt install mysql-server
  • For secure installation type following command:
sudo mysql_secure_installation
  • MySQL will automatically started after completion of installation process. Then check MySQL server is running or not using this command:
sudo systemctl status mysql
  • To log into the MySQL server as the root user type following command:
sudo mysql
  • MySQL shell can be exit using following command:
exit

Explore

To learn about other open source relational database management systems, please check following pages: