Linux system MySQL8.0.19 quick installation and configuration tutorial diagram

1. Environment Introduction

Installing MySQL on Linux using yum requires downloading a series of MySQL components from the Internet. This process is very time-consuming and there is a possibility of download interruption. If you want to install MySQL quickly, you can first download the offline package of MySQL from the Internet and transfer it to the system for installation. This article takes CentOS7 and MySQL8.0.19 as an example to explain

A quick installation and configuration method for MySQL.

1. Operating system: CentOS7_x64
2. Database version: MySQL-8.0.19

Offline package download:

Link: https://pan.baidu.com/s/1OdehL8MoCe44nJ-SkkW8xw Extraction code: fk2d

2. Install MySQL-8.0.19

After decompressing the MySQL compressed file, you will get the following rpm file list:

The following rpm packages need to be installed in order:

mysql-community-common-8.0.19-1.el7.x86_64.rpm
mysql-community-libs-8.0.19-1.el7.x86_64.rpm
mysql-community-client-8.0.19-1.el7.x86_64.rpm
mysql-community-server-8.0.19-1.el7.x86_64.rpm
Installation command:
rpm -ivh rpm package name

Note: Before installing mysql-community-libs package, you need to uninstall the mariadb-libs package that comes with Linux, otherwise the installation will fail:

rpm -qa | grep mariadb-libs*
rpm -e --nodeps mariadb-libs*

After the installation is complete, start MySQL and log in to verify that the installation was successful:

systemctl start mysqld
cat /var/log/mysqld.log | grep password
mysql -uroot -p
enter password:

3. Configure MySQL

1. The initial MySQL password is complex and difficult to remember. It needs to be modified after the first login:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

2. Develop MySQL connection permissions so that it can be accessed by remote connection tools:

UPDATE mysql.user SET `Host`='%' WHERE User='root';
flush privileges;

If you do not have the permission to open the connection, the following error will be reported when you use a client such as Navicat to connect to the database:

3. Restore the password verification plug-in and change the password authentication plug-in of MySQL8 from caching_sha2_password to mysql_native_password:

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'passowrd';

If the plug-in is not replaced, the following error will be reported during connection:

4. Open port 3306 on the firewall and set MySQL to start automatically at boot:

firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl enable mysqld

Summarize

This is the end of this article about the illustrated tutorial on the quick installation and configuration of MySQL 8.0.19 on Linux. For more information about the installation and configuration of MySQL 8.0.19 on Linux, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!