centos7 安装mysql8 自己安装记录

 安装小计

 mysql安装有多种方法，本文采用压缩包安装

 由于mysql官网地址下载较慢，本文使用腾讯云镜像下载mysql8，下载命令为：

wget https://mirrors.cloud.tencent.com/mysql/downloads/MySQL-8.0/mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz

本文参考博客地址为：centos7环境下mysql8的tar包的安装及配置_何小杰的博客-CSDN博客， 具体安装步骤可参考此篇博文。

记录一下my.cnf的配置，具体mysql地址可根据以下配置自行更改

[client]
port=3306
socket=/usr/local/soft/mysql/data/mysql.sock
[mysqld]
port=3306
user=mysql
socket=/usr/local/soft/mysql/data/mysql.sock
basedir=/usr/local/soft/mysql/mysql-8.0.21
datadir=/usr/local/soft/mysql/mysql-8.0.21/data
log-error=/usr/local/soft/mysql/data/error.log
pid-file =/usr/local/soft/mysql/data/mysql.pid
transaction_isolation = READ-COMMITTED
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
lower_case_table_names = 1
sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
default_authentication_plugin=mysql_native_password

注： my.cnf 文件默认在 /etc 文件下，需要修改时，直接进行替换

远程访问客户端授权命令：

use mysql;

update user set user.Host='%' where user.User='root';
flush privileges;

grant all privileges on *.* to 'root'@'%';
flush privileges;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;

quit

安装中途的错误：如果mysql 没有放在/usr/local文件底下，在执行下面命令后，需将/etc/init.d/mysql文件中所有的 '/usr/local/mysql'路径改为自己mysql对应的路径

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql