linux 安装mysql详解步骤

 按照步骤一步一步复制粘贴就可以了！！！

# 清理操作系统，将系统自带mysql删除，并将my.cnf配置文件变更文件名(没有说明没有安装)
yum remove mysql mariadb
mv /etc/my.cnf "/etc/my.cnf.bak$(date +%Y%m%d%H%M%S)"

# 安装必要的依赖包
yum install -y ncurses-devel ncurses-compat-libs libaio-devel

# 创建mysql用户
groupadd -g 3306 mysql
useradd -r -u 3306 -g mysql -s /sbin/nologin mysql

# 将压缩包移动到/usr/local/src目录下
mv mysql-8.0.28-el7-x86_64.tar.gz /usr/local/src/

# 进入压缩包所在目录
cd /usr/local/src/

# 解压得到mysql-8.0.28-el7-x86_64文件夹
tar -zxvf mysql-8.0.28-el7-x86_64.tar.gz

# 创建mysql文件夹，将解压好的mysql文件夹移动到此目录下
mkdir /usr/local/mysqldb
mv ./mysql-8.0.28-el7-x86_64 /usr/local/mysqldb/

# 创建符号链接
ln -s /usr/local/mysqldb/mysql-8.0.28-el7-x86_64 /usr/local/mysqldb/mysql

# 创建数据文件、日志文件目录
mkdir -p /usr/local/mysqldb/mysql/{logs,data,mysql-files}
chmod 700 /usr/local/mysqldb/mysql/mysql-files

# 修改mysql拥有者
chown -R mysql.mysql /usr/local/mysqldb

# 将mysql命令路径添加到环境变量PATH，并使之立即生效
echo 'export PATH=$PATH:/usr/local/mysqldb/mysql/bin' >> ~/.bash_profile
source ~/.bash_profile

#进入my.cnf
vim /etc/my.cnf

# 创建mysql参数文件my.cnf，内容如下
[mysqld]
bind_address=0.0.0.0
port=3306
max_allowed_packet=16M
max_connections=1000
socket=mysql.sock
mysqlx_socket=mysqlx.sock
skip_name_resolve=on
authentication_policy='mysql_native_password,,'
basedir=/usr/local/mysqldb/mysql
datadir=/usr/local/mysqldb/mysql/data
secure_file_priv=/usr/local/mysqldb/mysql/mysql-files
log_error=/usr/local/mysqldb/mysql/logs/error.log
log_timestamps=system
slow_query_log=on
long_query_time=3
min_examined_row_limit=0
slow_query_log_file=/usr/local/mysqldb/mysql/logs/slow_query.log
character_set_server=utf8mb4
explicit_defaults_for_timestamp = 1
lower_case_table_names=1
autocommit=1
transaction_isolation=read-committed
log_bin=mysql-bin
log-bin-index=mysql-bin.index
sync_binlog=1
binlog_format=row
binlog_row_image=full
max_binlog_size=1G
binlog_expire_logs_seconds=691200
default_storage_engine=InnoDB
innodb_strict_mode=on
innodb_file_per_table=on
innodb_print_all_deadlocks=on
innodb_log_file_size=100M
innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1
innodb_buffer_pool_size=128M
innodb_flush_method=O_DIRECT
innodb_undo_log_truncate=on
innodb_max_undo_log_size=100M
innodb_purge_rseg_truncate_frequency=128

[client]
socket=/usr/local/mysqldb/mysql/data/mysql.sock

# 初始化数据目录
mysqld --initialize --user=mysql

# 临时启动mysqld，修改root密码
mysqld --user=mysql --skip-grant-tables --skip-networking &
mysql -uroot
flush privileges;
alter user root@localhost identified by '123456';
flush privileges;
exit

# 重启mysql
kill -15 `pidof mysqld`
mysqld_safe --user=mysql &