Chuẩn bị các lib cần dùng:

yum group install "Development Tools" -y

yum install libaio numactl -y

Bước 1: Tải source mysql (version 8.0.33)

wget "https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-el7-x86_64.tar.gz"

Bước 2: Giả nén mysql

tar -xvf mysql-8.0.33-el7-x86_64.tar.gz

Bước 3:  Create user mysql 

useradd mysql

Bước 4: Create file tmp chứa password root mysql

echo "ALTER USER 'root'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'hocdev@123';" > /tmp/mysql

Bước 5: Create folder + file log mysql

mkdir -p /data/mysql01 /data/logs/mysql
touch /data/logs/mysql/mysql01-err.log
touch /data/logs/mysql/mysql01-slow.log
touch /data/logs/mysql/mysqlmulti.log
chown -Rf mysql.mysql /data/mysql01 /data/logs/*

Bước 6: Create file my.cnf (copy các server đang chạy)

[mysql]
prompt=mysql:\\u@\\h:\\p/\\d>\\_
 
[client]
port            = 3306
socket          = /data/mysql01/mysql01.sock
 
[mysqld_multi]
mysqld=/opt/mysql-8.0.33-el7-x86_64/bin/mysqld_safe
mysqladmin=/opt/mysql-8.0.33-el7-x86_64/bin/mysqladmin
log=/data/mysqlmulti_log/mysqlmulti.log
 
###
[mysqld1]
mysqld     = /opt/mysql-8.0.33-el7-x86_64/bin/mysqld_safe
ledir      = /opt/mysql-8.0.33-el7-x86_64/bin
mysqladmin = /opt/mysql-8.0.33-el7-x86_64/bin/mysqladmin
user=mysql
default_authentication_plugin=mysql_native_password
port            = 3306
bind-address    = 0.0.0.0
server-id=1
ft_stopword_file=""
ft_min_word_len = 2
performance_schema=ON
secure_file_priv=""
datadir=/data/mysql01/
socket=/data/mysql01/mysql01.sock
pid-file=/data/mysql01/mysql01.pid
log-error=/data/logs/mysql/mysql01-err.log
long_query_time=1
slow_query_log=1
slow_query_log_file=/data/logs/mysql/mysql01-slow.log
general-log = 0
general_log_file =/data/logs/mysql/mysql01.log
character-set-server = utf8
connect_timeout = 5
interactive_timeout = 600
wait_timeout = 10
max_connections = 1200
max_user_connections = 1150
max_connect_errors = 99999
thread_cache_size = 128
mysqlx-port=0
log_bin_trust_function_creators=1
binlog_expire_logs_seconds=864000
###

Bước 7: intialize database

/opt/mysql-8.0.33-el7-x86_64/bin/mysqld --defaults-file=/opt/mysql-8.0.33-el7-x86_64/conf/my8.cnf --initialize --console --user=mysql --basedir=/opt/mysql-8.0.33-el7-x86_64/ --datadir=/data/mysql01

Bước 8: Change password root database

/opt/mysql-8.0.33-el7-x86_64/bin/mysqld --defaults-file="/opt/mysql-8.0.33-el7-x86_64/conf/my8.cnf" --init-file=/tmp/mysql --user=mysql --basedir=/opt/mysql-8.0.33-el7-x86_64/ --datadir=/data/mysql01 --console --socket=/data/mysql01/mysql01.sock --port=3306

Bước 9: Kill -term mysql

Bước 10: Check + start + shutdown mysql

ln -s /opt/mysql-8.0.33-el7-x86_64/bin/my_print_defaults /usr/local/bin/

/opt/mysql-8.0.33-el7-x86_64/bin/mysqld_multi --defaults-file="/opt/mysql-8.0.33-el7-x86_64/conf/my8.cnf" report => check mysql 

/opt/mysql-8.0.33-el7-x86_64/bin/mysqld_multi --defaults-file="/opt/mysql-8.0.33-el7-x86_64/conf/my8.cnf" start 1 => start mysql

/opt/mysql-8.0.33-el7-x86_64/bin/mysqladmin -S/data/mysql01/mysql01.sock -p shutdown

Bước 11: tạo file connect mysql

/opt/mysql-8.0.33-el7-x86_64/bin/mysql --prompt="(\u@\h) [\d]>" -u root -S /data/mysql01/mysql01.sock -p