Here’s a quick guide to setting up the popular database server MySQL on Ubuntu 16.04.
Install MySQL
Update repositories
sudo apt-get update
Install MySQL
sudo apt-get install mysql-server
Enter a root password when prompted
Secure the installation
sudo mysql_secure_installation
Personally, I don’t use the validate password plugin, keep my root password, disable remote root login and remove test databases. How you answer these questions will depend on the purpose of the install.
That’s it!
You can login through the command line with
mysql -u root -p
You’ll be prompted for the root password set during installation.