Brief analysis of centos 7 mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

Brief analysis of centos 7 mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

Baidu Cloud Disk:

Link: https://pan.baidu.com/s/1hv5rUWYK080hCuONqpSVCg Extraction code: qhgp

Installation Instructions:

https://www.jb51.net/article/138787.htm

Operation log

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_64.rpm --nodeps --force
 48 rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.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

Use cat /var/log/mysqld.log | grep password command to view the database password.

Press Enter key to enter the database login interface through mysql -uroot -p

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

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

.Authorize 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;

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

Command to modify the encryption rules. The encryption rules of MySql 8.0 and 5.0 are different, and the current visualization tool only supports the old encryption method.

Refresh the modified permissions by using flush privileges; command

Use the following command to turn off the firewall:

systemctl stop firewalld.service;
systemctl disable firewalld.service;
systemctl mask firewalld.service;

Summarize

The above is the centos 7 mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!

You may also be interested in:
  • CentOS7 uses rpm to install MySQL 5.7 tutorial diagram
  • Detailed tutorial on installing mysql 8.0.13 (rpm) on Centos7
  • Installation tutorial of mysql8.0rpm on centos7
  • Solution to the initialization error when installing mysql5.7 from rpm package in centos6.5
  • Install MySQL 5.7.18 using rpm package under CentOS 7
  • Alibaba Cloud Centos7.3 installation mysql5.7.18 rpm installation tutorial
  • CentOS7 uses rpm package to install mysql 5.7.18
  • Tutorial on installing MySQL 5.7.9 using RPM package under CentOS 7
  • Install mysql5.7.13 using RPM in CentOS 7
  • CentOS7 detailed installation of MySQL using rpm

<<:  Docker implements cross-host container communication based on macvlan

>>:  Vue3+script setup+ts+Vite+Volar project

Recommend

js precise calculation

var numA = 0.1; var numB = 0.2; alert( numA + num...

Windows Server 2016 Standard Key activation key serial number

I would like to share the Windows Server 2016 act...

Use of Linux telnet command

1. Introduction The telnet command is used to log...

Don't forget to close the HTML tag

Building web pages that comply with Web standards ...

Solution to span width not being determined in Firefox or IE

Copy code The code is as follows: <html xmlns=...

Implementation of whack-a-mole game in JavaScript

This article shares the specific code for JavaScr...

HTML table tag tutorial (32): cell horizontal alignment attribute ALIGN

In the horizontal direction, you can set the cell...

Implementation of Docker to build private warehouse (registry and Harbor)

As more and more Docker images are used, there ne...

MySQL Optimization Solution Reference

Problems that may arise from optimization Optimiz...

Vue implements login jump

This article example shares the specific code of ...

MySQL statement execution order and writing order example analysis

The complete syntax of the select statement is: S...

Complete steps to configure basic user authentication at the Nginx level

Preface Application scenario: probably the intern...

Linux automatically deletes logs and example commands from n days ago

1. Delete file command: find the corresponding di...