CentOS7安装-MySQL8.0.24

自定义安装,安装路径[/usr/local/application/mysql/mysql-8.0.24-3310]

安装之前还要安装其他的插件,根据提示自行安装

下载

wget https://www.yuan67.top/resources/mysql-8.0.24.tar.xz

解压

tar -xvf ./mysql-8.0.24.tar.xz

更改文件夹名称

mv mysql-8.0.24 mysql-8.0.24-3310

创建配置文件[my.cnf]

my.cnf

[client]
port=3310
socket=/usr/local/application/mysql/mysql-8.0.24-3310/mysql8.sock

# The MySQL server
[mysqld]
port=3310
mysqlx_port=33100
user=mysql
socket=/usr/local/application/mysql/mysql-8.0.24-3310/mysql8.sock
mysqlx_socket=/usr/local/application/mysql/mysql-8.0.24-3310/mysqlx8.sock
pid-file=/usr/local/application/mysql/mysql-8.0.24-3310/mysql8.pid
basedir=/usr/local/application/mysql/mysql-8.0.24-3310
datadir=/usr/local/application/mysql/mysql-8.0.24-3310/data
tmpdir=/usr/local/application/mysql/mysql-8.0.24-3310/tmp
open_files_limit=60000
explicit_defaults_for_timestamp
server-id=1203307
lower_case_table_names=1
character-set-server=utf8mb4
federated
max_connections=1000
max_connect_errors=100000
interactive_timeout=86400
wait_timeout=86400
back_log=100

default-storage-engine=InnoDB

#*********** GTID settting*******************
log_slave_updates=1
gtid_mode=ON
enforce-gtid-consistency=true
innodb_flush_log_at_trx_commit=2
binlog_format=row
skip-slave-start=1
sync_binlog=5

#*********** Logs related settings ***********
log-bin=/usr/local/application/mysql/mysql-8.0.24-3310/binlog/mysql-bin
binlog_cache_size=32m
max_binlog_cache_size=64m
max_binlog_size=512m
long_query_time=1
log_output=FILE
log-error=/usr/local/application/mysql/mysql-8.0.24-3310/logs/mysql-error.log
slow_query_log=1
slow_query_log_file=/usr/local/application/mysql/mysql-8.0.24-3310/logs/slow_statement.log
general_log = 0
general_log_file=/usr/local/application/mysql/mysql-8.0.24-3310/logs/general_statement.log
binlog_expire_logs_seconds=1728000
relay-log=/usr/local/application/mysql/mysql-8.0.24-3310/binlog/relay-bin
relay-log-index=/usr/local/application/mysql/mysql-8.0.24-3310/data/mysqldata/3307/binlog/relay-bin.index

#****** MySQL Replication New Feature*********
master-info-repository=TABLE
relay-log-info-repository=TABLE
relay-log-recovery

[mysql]
no-auto-rehash
default-character-set=utf8mb4
socket=/usr/local/application/mysql/mysql-8.0.24-3310/mysql8.sock

启动MySQL

当前目录[/usr/local/application/mysql/mysql-8.0.24-3310]

./bin/mysqld_safe --defaults-file=/usr/local/application/mysql/mysql-8.0.24-3310/my.cnf  --user=mysql &

登录MySQL

当前目录[/usr/local/application/mysql/mysql-8.0.24-3310]

./bin/mysql -uroot -P3310 -h localhost --socket=/usr/local/application/mysql/mysql-8.0.24-3310/mysql8.sock -p

MySQL密码位置[/usr/local/application/mysql/mysql-8.0.24-3310/logs/mysql-error.log]

例如我这个mysql密码就是 #p<>0,tS%zjN

A temporary password is generated for root@localhost: #p<>0,tS%zjN

第一次登录要修改密码

第一次登录要修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword' 

刷新配置

刷新配置

FLUSH PRIVILEGES;

配置外部访问

配置外部访问

use mysql;
update user set host = "%" where user = "root";