初始化小于等于2 TiB数据盘（Linux）_云服务器 ECS-阿里云帮助中心

先挂好磁盘 分好区

1.环境准备 一台centos7.9系统主机

2.mysql-8.0.25-1.el7.x86_64.rpm-bundle.tar

开始安装：

1. 查询mariadb 并卸载 查询Mysql并删除 解压tar包

rpm -qa|grep mariadb
rpm -e --nodeps  查询出来的包
rpm -pa | grep mysql
find / -name mysql  
rm -rf 查出来的mysql目录
yum -y install mysql-community-*
 

2. 打开 /etc/my.cnf  编辑以下信息

[mysqld]

user            = mysql
pid-file        = /data/mysql_data/mysql/mysqld.pid
datadir = /data/mysql_data/mysql
socket=/data/mysql_data/mysql/mysql.sock
log-error=/data/mysql_data/mysql/mysqld.log
max_connections=5000
max_connect_errors=100
default-storage-engine=INNODB

bind-address=0.0.0.0
server_id=10
log_bin=mysql-bin
binlog_format=ROW
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

mysqlx-bind-address     = 0.0.0.0
table_open_cache = 65535
open_files_limit = 65535

key_buffer_size         = 16M

myisam-recover-options  = BACKUP

max_binlog_size   = 100M

3.创建好数据目录
 

mkdir -p /data/mysql_data/mysql

systemctl daemon-reload

systemctl enable mysqld --now

netstat -nutlp | grep :3306

cat /data/mysql_data/mysql/mysqld.log  | grep localhost

ln -sv /data/mysql_data/mysql/mysql.sock /var/lib/mysql/mysql.sock

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';

flush privileges;

update mysql.user set host='%' where user='root';

flush privileges；

SHOW VARIABLES LIKE 'validate_password%';

set global validate_password.policy=LOW

set global validate_password.length=1;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '***';

flush privileges;

set global binlog_expire_logs_seconds=259200;

flush logs；

show variables like '%expire%';