Install and Configure MySQL Server (CentOS)

In the cloud_user home directory run the following:

# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar

In cloud_user’s home directory, Use the tar command to extract the RPM files from the bundle tar file:

[cloud_user@host]$ tar -xvf mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar

In cloud_user’s home directory, use the rpm command to install the MySQL server and dependencies:

[cloud_user@host]$ sudo rpm -Uvh mysql-community-{server,client,common,libs}-*

Use systemctl to start up the mysqld service:

[cloud_user@host]$ sudo systemctl start mysqld

Locate the temporary password for the superuser:

[cloud_user@host]$ sudo grep 'temporary password' /var/log/mysqld.log

Using the temporary password, log into the MySQL server as the root user:

[cloud_user@host]$ # mysql -u root -p

Update the password for the root user:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '<NEW_PASSWORD>';

For grading purposes, make sure NEW_PASSWORD is Linux4me!.

Exit the mysql prompt:

mysql> exit

Begin the installation by running the mysql_secure_installation command:

cloud_user@host]$ mysql_secure_installation

Answer the following questions to complete the secure installation:

Change the password for root ? n
Remove anonymous users? y
Disallow root login remotely? y
Remove test database and access to it? y
Reload privilege tables now? y