mysql8.0安装（linux下，二进制安装）

            mkdir /soft
#上传，无论是rz，或者其他客户端工具，或者用的linux下载直接copy/mv，把文件放到/soft 目录下

            #以前的 .gz的压缩表使用 -zxvf,现在 .xz的压缩包使用 -Jxvf
tar -Jxvf mysql-8.0.20-linux-x86_64-minimal.tar.xz

            ln -s mysql-8.0.20-linux-x86_64-minimal mysql

            查看SELinux状态：


            1、/usr/sbin/sestatus -v      ##如果SELinux status参数为enabled即为开启状态
SELinux status:                 enabled

2、getenforce                 ##检查当前限制级别

            #1
            、临时关闭（不用重启机器）：
   setenforce 
            0
                              ##设置SELinux 成为permissive模式
   　　　　　　　　　　　　　　　　　　##setenforce 
            1
             设置SELinux 成为enforcing模式

            #2
            、修改配置文件需要重启机器：

修改/etc/selinux/config 文件
将SELINUX=enforcing改为SELINUX=disabled

            stop firewalld
status firewalld
        

            echo
            "
            export PATH=${PATH}:/soft/mysql/bin
            "
            echo
            "
            export PATH=${PATH}:/soft/mysql/bin
            ">>/etc/profile
source /etc/profile

            groupadd mysql
useradd mysql -g mysql -s /sbin/nologin

            mkdir -p /data/mysql/3306mkdir -p /data/mysql/3306/data
chmod755 -R /data/mysql
chown -R mysql:mysql /data/mysql
umask 0022 /data/mysql

            [client]
port = 3306
socket = /data/mysql/3306/mysql.sock
default-character-set=utf8mb4

[mysql]
disable-auto-rehash #允许通过TAB键提示
default-character-set = utf8mb4
connect-timeout = 10

[mysqld]
user=mysql
server-id = 3306
port = 3306
socket = /data/mysql/3306/mysql.sock
pid-file = /data/mysql/3306/mysql.pid
basedir = /soft/mysql
datadir = /data/mysql/3306/data
#bind_address = 10.10.10.11
autocommit = 1

default_authentication_plugin=mysql_native_password
character-set-server=utf8mb4
explicit_defaults_for_timestamp=true
lower_case_table_names=1
back_log=103
max_connections=10000
max_connect_errors=100000
table_open_cache=512
external-locking=FALSE
max_allowed_packet=32M
sort_buffer_size=2M
join_buffer_size=2M
thread_cache_size=51
transaction_isolation=READ-COMMITTED
tmp_table_size=96M
max_heap_table_size=96M



###***logs
long_query_time = 10
slow_query_log = 1
slow_query_log_file=/data/mysql/3306/slow.log

#log-warnings = 1
log_error_verbosity=3

log-error = /data/mysql/3306/mysql.err
log_output = FILE #参数log_output指定了慢查询输出的格式，默认为FILE，你可以将它设为TABLE，然后就可以查询mysql架构下的slow_log表了


#log-queries-not-using-indexes
#log-slow-slave-statements
max_binlog_size = 1G
#max_relay_log_size = 1G

# replication
log-bin=/data/mysql/3306/mysql-bin
#server-id=1
#binlog_format= ROW
#gtid_mode = on
#enforce_gtid_consistency = 1
#log_slave_updates   = 1
#master-info-repository=TABLE
#relay-log-info-repository=TABLE

# innodb storage engine parameters
innodb_buffer_pool_size=500M
innodb_data_file_path=ibdata1:100M:autoextend:max:5G #redo
innodb_temp_data_file_path = ibtemp1:100M:autoextend:max:10G
#innodb_file_io_threads=4 #默认的是4
innodb_log_buffer_size=16M
innodb_log_file_size=256M #undo
innodb_log_files_in_group=2
innodb_lock_wait_timeout=50
innodb_file_per_table=1 #独立表空间

mysqld --defaults-file=/etc/my.cnf --datadir=/data/mysql/3306/data --user=mysql  --initialize-insecure --console 

            cat mysql.err|grep"[error]"

mysqld_safe --defaults-file=/etc/my.cnf &

alter user root@localhost identified with mysql_native_password by ‘123456‘;
flush privileges;