CentOS7 Linux下安装MySQL8

1. 下载MySQL

注意选择如下图：

2.安装MySQL

上传本地下载的的安装包

解压

tar -xvf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

安装命令

 rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm --nodeps --force

 rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm --nodeps --force

 rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm --nodeps --force

 rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm --nodeps --force

3.修改my.cnf

vim /etc/my.cnf

 
[mysqld]
port=3306
 
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
 
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
init_connect='SET NAMES utf8mb4'
 
lower_case_table_names=1
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
 
skip-external-locking
skip_name_resolve
max_connect_errors=10
 
slow_query_log=on
long_query_time=3
slow_query_log_file=/var/log/slowsql.log
 
key_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_allowed_packet=1M
table_open_cache=64
sort_buffer_size=512K
net_buffer_length=8K

4.启动MySQL，修改登录密码

启动MySQL

systemctl start mysqld.service

然后执行初始化命令（指定mysql用户）：

mysqld --user=mysql --initialize

#####  命令查看随机密码：cat /var/log/mysqld.log | grep password

systemctl start mysqld

mysql -uroot -p 回车，然后复制前面查到的随机密码粘贴过来，

alter user ‘root’@‘localhost’ identified by ‘123456’;

输入代码把root用户的Host修改为%。
use mysql
update user set host = ‘%’ where user =‘root’;
flush privileges;