MySQL has recently announced the release of MySQL80 and seems like a lot of improvement has been made. So let’s start with installing it from official’s repository.
You can get appropriate repository file from MySQL :: Download MySQL Yum Repository. To install it,
1
yum install https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
Two .repo files will be placed after installation.
With these two files, we can start MySQL80 installation.
1
yum install mysql-community-server
Start mysql service and check status after installation.
1
2
systemctl start mysqld
systemctl status mysqld
Next, we need to obtain the temporary password first initializing mysql service.
1
cat /var/log/mysqld.log | grep "temporary password"
Now we start mysql initialization.
1
mysql_secure_installation
Now we are all set, login to mysql with user root
and the password you just set.
1
mysql -u root -p
You should be able to login if everything was setup correctly. And to wrap everything up with couple commands to interact with mysql server and everything works fine and as expected!