my.cnf
[client]
port = 3306
socket = /home/xxx/apps/mysql-8.0.26/tmp/mysql.sock
[mysqld_safe]
socket = /home/xxx/apps/mysql-8.0.26/tmp/mysql.sock
nice = 0
[mysqld]
user = credit
pid-file = /home/xxx/apps/mysql-8.0.26/tmp/mysqld.pid
socket = /home/xxx/apps/mysql-8.0.26/tmp/mysql.sock
port = 3306
basedir = /home/xxx/apps/mysql-8.0.26/
datadir = /home/xxx/apps/mysql-8.0.26/data
tmpdir = /home/xxx/apps/mysql-8.0.26/tmp
default-time_zone='+8:00'
skip-external-locking
bind-address = 0.0.0.0
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
#query_cache_limit = 1M
#query_cache_size = 16M
log_error = /home/xxx/apps/mysql-8.0.26/logs/mysql_error.log
explicit_defaults_for_timestamp
default-storage-engine=INNODB
server-id = 1
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
init.sh
#!/bin/sh
mysql_home=/home/xxx/apps/mysql-8.0.26
./bin/mysqld --user=root --basedir=$mysql_home --datadir=$mysql_home/data --initialize
startup.sh
#!/bin/sh
path=/home/xxx/apps/mysql-8.0.26
#$path/bin/mysqld --defaults-file=$path/my.cnf --initialize-insecure --console
nohup $path/bin/mysqld --defaults-file=$path/my.cnf --user=credit >$path/logs/out.log 2>&1 &
#$path/bin/mysql_upgrade --defaults-file=$path/my.cnf --user=root
conmysql.sh
#!/bin/sh
./bin/mysql -S tmp/mysql.sock -u root -p