Shulou(Shulou.com)06/01 Report--

Download the rpm package on the official website. The package dependency has not been solved. You need to download the following package.

Mysql-community-common-8.0.18-1.el7.x86_64.rpm

Mysql-community-libs-8.0.18-1.el7.x86_64.rpm

Mysql-community-client-8.0.18-1.el7.x86_64.rpm

Mysql-community-server-8.0.18-1.el7.x86_64.rpm

Use yum to install the package in the above order, with the following installation commands

Yum localinstall mysql-community-common-8.0.18-1.el7.x86_64.rpm

Start the mysqld service after a successful installation, with the following command

Systemctl start mysqld

After startup, use netstat to check whether the port is listening. The command is as follows

Netstat-lnp to see if port 3306 is listening

Set the MySQL account and password after opening it. After initializing the MySQL8.0 installation, the password will be output to the / var/log/mysqld.log log. Log in with the initial password, as shown below.

Mysqld-uroot-p

Create a new corresponding user and weight in MySQL, as follows

The mysql > alter user 'root'@'localhost' identified with mysql_native_password by' Evildragonfly@23'; option supports naticat for password encryption format

Mysql > CREATE USER 'root'@'%' IDENTIFIED BY' Evildragonfly@23'; needs to create a user before it can be authorized to the user

Mysql > GRANT ALL PRIVILEGES ON. TO 'root'@'%' WITH GRANT OPTION; makes grant declaration authorization for the created user

Mysql > flush privileges; refresh cache

Complete the MySQL8.0 installation. After the installation, please pay attention to the permissions of firewalld and color Linux to avoid the problem of disconnection.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.