Shulou(Shulou.com)05/31 Report--

This article mainly introduces an example of the operation of mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar in centos7, which has a certain reference value, and interested friends can refer to it. I hope you will gain a lot after reading this article.

Operation record

Mkdir mysql 40 ll 41 cd my 42 cd mysql/ 43 ll 45 tar-xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar 46 ll 47 rpm- ivh mysql-community-common-8.0.19-1.el7.x86 ll 64.rpm-- nodeps-- force 48 rpm- ivh mysql-community-libs-8.0.19-1.el7.x86room64.rpm-- nodeps-- force 49 rpm- ivh mysql-community-client-8.0.19-1. El7.x86_64.rpm-nodeps-force 50 rpm-ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm-nodeps-force 51 rpm-qa | grep mysql 52 mysqld-initialize 53 chown mysql:mysql / var/lib/mysql-R; 54 systemctl start mysqld.service; 55 systemctl enable mysqld; 56 cat / var/log/mysqld.log | grep password 57 mysql-uroot-p 58 systemctl stop firewalld.service; 59 systemctl disable firewalld.service; 60 systemctl mask firewalld.service; 61 ifconfig

Check the password of the database through the command cat / var/log/mysqld.log | grep password

Enter the database login interface by hitting the enter key through mysql-uroot-p

Change the password through the ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' root'; command

Exit MySQL with the exit; command, and then log in again with the new password

. Authorization for remote access through the following command

Create user 'root'@'%' identified with mysql_native_password by' root';grant all privileges on *. * to 'root'@'%' with grant option;flush privileges

Through ALTER USER 'root'@'localhost' IDENTIFIED BY' root' PASSWORD EXPIRE NEVER

Command to modify the encryption rules, the MySql8.0 version is different from the 5.0 encryption rules, and today's visualization tools only support the old encryption methods.

Refresh the permissions after the revision through the flush privileges; command

Turn off firewall (firewall) with the following command

Systemctl stop firewalld.service;systemctl disable firewalld.service;systemctl mask firewalld.service; thank you for reading this article carefully. I hope the article "Operation examples of mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar in centos7" shared by the editor will be helpful to you. At the same time, I also hope that you will support us and follow the industry information channel. More related knowledge is waiting for you to learn!

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.