- A Cloud Guru
Install and Configure MySQL Server (Ubuntu)
MySQL server is one of the most popular and widely-used relational databases. In this lab, you will be tasked with installing a MySQL server on Ubuntu 18.04 and ensuring that it has been properly secured.
Table of Contents
Download the MySQL APT Repository Configuration File from the MySQL APT Repository Download Page
Download the MySQL APT repository configuration file from the MySQL APT repository download page. In the
cloud_user's home directory, run the following:
``` wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb ```
Install and Configure the Downloaded Release Package
Install the downloaded release package for the MySQL server and re-synchronize the package index files. In the package configuration window, make sure that the MySQL server and cluster is set to
mysql-8.0and the MySQL tools and connectors is
cloud_user’s home directory, use the
dpkgpackage manager to install the release package:
sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb
In the package configuration window, ensure that the MySQL Server and Cluster is set to
mysql-8.0, the MySQL Tools and Connectors is
Enabled, and the MySql Preview Packages is
Disabled, then hit
MySQL Server & Cluster (Currently selected: mysql-8.0) MySQL Tools & Connectors (Currently selected: Enabled) MySQL Preview Packages (Currently selected: Disabled)
Re-synchronize the package index:
sudo apt update -y
Install MySQL Server and Dependencies
aptcommand to install the MySQL server:
sudo apt install -y mysql-server
You are no longer required to enter the root password:
Linux4me!, then select Use Strong Password Encryption (RECOMMENDED).
Check the MySQL Server Status
Validate that the
mysqlservice is running:
sudo systemctl status mysql
Log in to the MySQL server as the
rootuser (enter password when prompted):
sudo mysql -u root -p
To log out of the mysql prompt, type
exitand hit enter.
Secure the MySQL Server Installation
Secure the MySQL server installation by ensuring that the validation password policy is set to strong, removing anonymous users, disabling remote
rootlogin, removing the
testdatabase, and reloading the privilege tables.
Begin the installation by running the
mysql_secure_installationcommand (enter the Linux4me! password when prompted):
Answer the following questions to complete the secure installation:
Would you like to setup VALIDATE PASSWORD plugin? y Set the level of the password validation password to STRONG: 2 Please set the password for root here: Linux4me! Do you wish to continue with the password provided? y Remove anonymous users? y Disallow root login remotely? y Remove test database and access to it? y Reload privilege tables now? y
What's a lab?
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.