top of page

MySql 8.0 on OEL 7.9

This article demonstrates MySQL 8.0.31 installation on OEL 7.9 version.

Now, we will use WGET utility to download the RPM.


Adding the MySQL Yum Repository

yum install -y mysql80-community-release-el7-7.noarch.rpm

Installing MySQL

yum install mysql-community-server -y

Start MySQL service and enable it to auto-start on reboot

# chkconfig mysqld on
# service mysqld start

Start the MySQL server with the following command:

# systemctl start mysqld

You can check the status of the MySQL server with the following command:

# systemctl status mysqld

A superuser account 'root'@'localhost' is created. A password for the superuser is set and stored in the error log file. To reveal it, use the following command

# grep 'temporary password' /var/log/mysqld.log

Change the root password as soon as possible by logging in with the generated, temporary password and set a custom password for the superuser account:

# mysql -uroot -p
mysql>ALTER USER 'root'@'localhost' IDENTIFIED BY 'P@ssword123'; 

Create MySQL Database

Once MySQL installation is done, let us connect to the database

Use the below command to create a new database

mysql> create database mydb;

List all the databases

mysql> show databases;

To switch between databases use the below command

mysql> exit

You can make new connections directly to the database as follows.

$ mysql --user=root --database=mydb --password
Enter password:

Installation Done!

Related Posts

Heading 2

Add paragraph text. Click “Edit Text” to customize this theme across your site. You can update and reuse text themes.

bottom of page