MySQL released it’s new version MySQL 8.0 under GNU. MySQL is an open-source Relational Database Management System(RDBMS). MySQL provide multiple database access on single server on each created database.
Changes in MySQL 8.0
- Changes in Data Dictionary
- Configuration Changes
- Server changes
- innoDB changes
- SQL changes
- Caching_sha2_password as the Preferred Authentication Plugin
Prerequisites
If you are already installed MySQL then you have to upgrade or replace it Using MySQL Yum repository. Before upgrading or replacing MySQL you must take backup of database. For fresh installation follow step –
Login SSH server as root user:
#ssh root@Server_IP
login as : root
password : password
Step1. Install Yum repository of MySQL 8
# wget https://repo.mysql.com/mysql80-community-release-el17-1.noarch.rpm
Install downloaded packages
# yum localinstall mysql80-community-release-el7-1.noarch.rpm
Now you can verify downloaded packages using this command
# yum repolist enabled | grep "mysql"
Step2. Install MySQL 8.0
After added yum packages run following command to install MySQL 8.0
# yum install mysql-community-server
Step3. Start the services of MySQL
# systemctl start mysqld # systemctl status mysqld # mysql --version
Step4 – setup secure server
In the latest version of MySQL 8.0 has feature to create temporary password in to a file /var/log/mysqld.log. we can grep this password using this command-
# grep 'temporary password' /var/log/mysqld.log
You have random password of MySQL database. Now you can start secure installation of MySQL database and reset you password and you can remove anonymous users. use following command-
#mysql_secure_installation
Step5. Connect with MySQL server
# mysql -u root -p