Install & Configure MySQL 8.0 in Redhat Enterprise Linux 7/8 | How to Install MySQL in Linux

MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.
======================================================
Install MySQL 8.0 on Red Hat Enterprise Linux 7/8:
---------------------------------------------------------------------------------
1) Login as root user. Download and add MySQL Yum Repository to Linux Repository
# wget https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm

2) Install the downloaded package by using below command
# yum localinstall mysql80-community-release-el7-1.noarch.rpm

3) Verify that the MySQL Yum repository has been added successfully
# yum repolist enabled | grep "mysql.*-community.*"

4) Install latest MySQL with below command:
# yum install mysql-community-server

5) Start MySQL Server, also enable it so that it can start it its on using below commands:
# systemctl start mysqld
# systemctl enable mysqld

Verify the status of the same.
# systemctl status mysqld

6) Secure MySQL Server:
When MySQL 8.0 version is installed, temporary password for root is created. Run below command to list the password.
# cat /var/log/mysqld.log | grep 'temporary password'

7) Get the password and then run below command.
# mysql_secure_installation
Enter the password you got in previous command, then change it with a new password.
============================
Now test the configuration:

1) Check the status of mysql server.
# systemctl status mysqld

2) Log in the mysql.
# mysql -u root -p
Enter the password, you have successfully logged in to the mysql.

3) Run different mysql commands to verify that its working fine.
# show databases;
# create database new;
# select * from mysql.user;

Thanks for watching.

================
Thanks for watching the video. Please like our videos, share with your friends and feel free to ask anything, post your queries in comments section. We will be glad to answer your queries. Don't forget to subscribe the channel & turn on the bell notifications.
===============
Our Some Popular Videos:

NAVIC:
https://www.youtube.com/watch?v=QoyQbmU2kg4

Learn Linux Fundamentals:
https://www.youtube.com/watch?v=9pqvIqIF_KI

Concept of All RAID Levels:
https://www.youtube.com/watch?v=VRx0copTNr8

Configure RAID-0 in Linux:
https://www.youtube.com/watch?v=5tTHGbSqSKA

Configure RAID-1 in Linux:
https://www.youtube.com/watch?v=x12pMJpGGmw

Configure RAID-5 in Linux:
https://www.youtube.com/watch?v=Cj-je1RUJgo

Configure RAID-6 in Linux:
https://www.youtube.com/watch?v=qeKLlrZ5fLg

Configure RAID-10 in Linux:
https://www.youtube.com/watch?v=DLVGj_Mu1DA

LVM Snapshot:
https://www.youtube.com/watch?v=CJJwbnFuM5A
====================================================
Contact Us:

To Follow Vikas Nehra's Twitter Handle:👇
http://bit.ly/VikasNehraTwitterHandle

For Registration:👇
http://bit.ly/NehraClassesRegForm

To Follow Our Twitter Handle:👇
http://bit.ly/NehraClassesTwiiterHandle

To Visit Our Facebook Page:👇
www.facebook.com/nehraclasses

To Follow Nehra Classes on Instagram:👇
https://www.instagram.com/nehraclasses/

To Our Visit Our Webpage:👇
http://bit.ly/NehraClassesWebpage

Join Us on Telegram App: 👇
https://t.me/NehraClasses

WhatsApp Us: 👇
https://bit.ly/2Kpqp5z

Email Us:👇
Email: nehraclasses@gmail.com
============
©COPYRIGHT. ALL RIGHTS RESERVED.

#NehraClasses #LinuxTraining #Trending

Видео Install & Configure MySQL 8.0 in Redhat Enterprise Linux 7/8 | How to Install MySQL in Linux канала Nehra Classes