MySQL 8 安装配置

最新版本：mysql-8.0.36
下载连接：https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.36-linux-glibc2.28-x86_64.tar

建用户、解压缩包、创建路径、安装相关依赖包等可以参考MySQL5.7安装过程
只是在配置文件中需要变动，可以参考如下配置

[client]
port       = 3306
socket     = /data/app/mysql/data/mysql.sock

[mysql]
prompt="\u@mysql8-01 \R:\m:\s [\d]> "
no-auto-rehash

[mysqld]
server-id                 = 801
log-bin                   = mysql-bin
sync_binlog               = 500
max_binlog_size           = 1G
user                      = mysql
port                      = 3306
basedir                   = /data/app/mysql
datadir                   = /data/app/mysql/data
socket                    = /data/app/mysql/data/mysql.sock
pid-file                  = /data/app/mysql/data/mysql.pid
log_error                 = /data/app/mysql/data/error.log
slow-query-log-file       = /data/app/mysql/data/slow.log
slow-query-log            = 1
skip_name_resolve         = 1
innodb_file_per_table     = 1
auto_increment_increment  = 1
auto_increment_offset     = 1
relay_log                 = mysql-relay
max_allowed_packet        = 128M

#GTID
gtid_mode                 = on
enforce-gtid-consistency  = 1

#slave
skip_replica_start        = 1
replica_parallel_workers  = 8
replica_preserve_commit_order=1
relay_log_recovery        = ON
read_only                 = 1
relay_log_purge           = 1
max_connections           = 16384
max_user_connections      = 16000

#innodb
default-storage-engine     = InnoDB
innodb_file_per_table      = 1
innodb_flush_log_at_trx_commit = 2

connect_timeout            = 60
tmp_table_size             = 256M
max_heap_table_size        = 256M
lower_case_table_names     = 1
interactive_timeout        = 1800

[mysqldump]
quick
max_allowed_packet = 128M

修改快速启动

sed -i "s#/usr/local/mysql#/data/app/mysql#g" $basedir/bin/mysqld_safe
sed -i "s#/usr/local/mysql#/data/app/mysql#g" $basedir/support-files/mysqld.server
cp /support-files/mysql.server /etc/init.d/mysqld
echo 'export PATH=/data/app/mysql/bin:$PATH'>> /etc/profile
source /etc/profile

初始化

/bin/mysqld --initialize --user=mysql

启动

service mysqld start

查看初始密码

cat $basedir/data/error.log |grep pass

登录数据库

mysql -uroot -p

首次登录需要修改最高用户密码，因为历史原因，最好使用mysql_native_password加密方式的密码

alter user root@'localhost' identified with mysql_native_password by 'root';

基础安装至此完成