How to install MySQL server on Ubuntu
MySQL is one of the most popular Open Source Relational DataBase Management System, RDBMS for short. MySQL is widely spread across the world, it is employed in enterprise environments as well as small hobbyist sites. Surprisingly, it is dead-simple to set it up and start using it on Ubuntu, let’s see how.
Requirements (before you start)
Databases workloads are among the most demanding ones. But that’s not true when you have a handful of small databases, and you do not perform many queries (operations). As a matter of fact you can install and get MySQL working on even the smallest 1GB RAM cloud instances without any issues.
Although mechanical hard drives have been used for databases for a long time, having a Solid State Drive holding your database will significantly improve your database performance.
You will need a running instance of Ubuntu to follow this tutorial, if you’re going to use MySQL server as a stable database (for a long time) I suggest you use a LTS version of Ubuntu such as Xenial Xerus or Bionic Beaver.
If everything is in order, let’s start.
MySQL has been available by default in Ubuntu repositories for a while so it’s quite easy to install, fire up your terminal and follow the steps:
That’s pretty much it, your database management system is already up and running, you can learn how to manage it, secure it as well as common operations in the following paragraphs.
Starting MySQL at boot
Accessing MySQL shell
Create a Database
Drop a Database (delete)
Create a User
Drop a User (delete)
After any privilege modification you should always reload the privileges to make sure they are enforced immediately.