How to Install MySQL 8.0 on CentOS/RHEL 8

    RahulBy 5 Mins ReadUpdated:

    MySQL is an open-source, relational database management system. At present, it is being developed under the Oracle Corporation. The MySQL 8 is the latest version available for the installation and use of the production application. MySQL 8.0 has many improvements and 2x processing speed over the previous version. In this version, MySQL team includes document store for developing both SQL and NoSQL document applications using a single database.

    This tutorial will help you to install MySQL 8 on CentOS 8 and RHEL 8 systems.

    Prerequisites

    You must have shell access with sudo privileged account on CentOS 8 system.

    Step 1 – Install MySQL

    The MySQL 8 packages are available under the AppStrem repository under CentOS 8. Install the required packages using the following command. This will also install multiple dependent packages.

    sudo dnf -y install @mysql

    After completing the installation, enable the MySQL service to auto-start on the system start. Also start service manually for the first time.

    sudo systemctl enable mysqld.service
sudo systemctl start mysqld.service

    Then check the service current status using the following command:

    sudo systemctl status mysqld.service

    ● mysqld.service - MySQL 8.0 database server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Tue 2020-02-25 04:43:13 UTC; 22s ago
 Main PID: 16666 (mysqld)
   Status: "Server is operational"
    Tasks: 39 (limit: 17963)
   Memory: 534.9M
   CGroup: /system.slice/mysqld.service
           └─16666 /usr/libexec/mysqld --basedir=/usr

Feb 25 04:43:04 tecadmin systemd[1]: Starting MySQL 8.0 database server...
Feb 25 04:43:04 tecadmin mysql-prepare-db-dir[16582]: Initializing MySQL database
Feb 25 04:43:13 tecadmin systemd[1]: Started MySQL 8.0 database server.

    Step 2 – Secure MySQL Installation

    The MySQL installation has been completed. Now you can connect the MySQL server without any password but we recommend to secure the MySQL installation. The MySQL packages provide mysql_secure_installation command to apply the security. Just run the below command on terminal:

    sudo mysql_secure_installation

    and follow the on-screen instructions. Below are the details which require user input.

    • Press y|Y for Yes, any other key for No: y
    • Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 2
    • New password: [ENTER STRONG PASSWORD HERE]
    • Re-enter new password: RE ENTER PASSWORD HERE
    • Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y
    • Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
    • Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
    • Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
    • Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

    Step 3 – Connect MySQL

    You have finished the installation and secured the MySQL server. Now connect to MySQL server via console or install phpMyAdmin to use a graphical web interface.

    mysql -u root -p

    Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

    Step 4 – Create Database and User

    It’s not recommended to use ‘root’ users to connect databases from applications. So it is a good idea to create a separate user for your application database connection. Below are the commands to create a new MySQL database, then create a new MySQL user and assign privileges on the database.

    You can change the database and user name as per your requirements. Also, use a strong password for the user.

    mysql> CREATE DATABASE tecadmin;
Query OK, 1 row affected (0.01 sec)

mysql> CREATE USER 'tecadmin'@'localhost' IDENTIFIED BY 'your secure password here';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL ON tecadmin.* to 'tecadmin'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

    Now, connect to MySQL server using the newly created user and list available databases.

    mysql -u tecadmin -p

    Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 8.0.17 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| tecadmin           |
+--------------------+
2 rows in set (0.01 sec)

mysql>

    Conclusion

    You have successfully installed and configured MySQL 8.0 on CentOS 8 system. Your server is ready for production use. You may also require to configure automated database backup script for the production system.

    Share.

    Related Posts

    Leave A Reply