centos7.6arm安装mysql8.0.17_如何在CentOS7.6上安装MySQL8.0

增加配置文件/etc/my.cnf

vim /etc/my.cnf

cat /etc/my.cnf

[client]

port            = 3306

socket          = /home/data/mysql/mysql.sock

[mysql]

no-auto-rehash

[mysqld]

user    = mysql

port    = 3306

socket  = /home/data/mysql/mysql.sock

basedir = /opt/mysql

datadir = /home/data/mysql/data

back_log = 600

max_connections = 800

max_connect_errors = 3000

external-locking = FALSE

max_allowed_packet =8M

sort_buffer_size = 1M

join_buffer_size = 1M

thread_cache_size = 100

#default_table_type = InnoDB

thread_stack = 192K

#transaction_isolation = READ-COMMITTED

tmp_table_size = 2M

max_heap_table_size = 2M

long_query_time = 1

#log_long_format

#log-error = /home/data/mysql/error.log

#log-slow-queries = /home/data/mysql/slow.log

pid-file = /home/data/mysql/mysql.pid

log-bin = /home/data/mysql/logs/mysql-bin

relay-log = /home/data/mysql/logs/relay-bin

relay-log-info-file = /home/data/mysql/logs/relay-log.info

binlog_cache_size = 1M

max_binlog_cache_size = 1M

max_binlog_size = 2M

expire_logs_days = 7

key_buffer_size = 16M

read_buffer_size = 1M

read_rnd_buffer_size = 1M

bulk_insert_buffer_size = 1M

#myisam_sort_buffer_size = 1M

#myisam_max_sort_file_size = 10G

#myisam_max_extra_sort_file_size = 10G

#myisam_repair_threads = 1

#myisam_recover

lower_case_table_names = 1

skip-name-resolve

slave-skip-errors = 1032,1062

replicate-ignore-db=mysql

server-id = 1

innodb_buffer_pool_size = 32M

innodb_data_file_path = ibdata1:128M:autoextend

innodb_thread_concurrency = 8

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 2M

innodb_log_file_size = 4M

innodb_log_files_in_group = 3

innodb_max_dirty_pages_pct = 90

innodb_lock_wait_timeout = 120

innodb_file_per_table = 0

[mysqldump]

quick

max_allowed_packet = 2M

[mysqld_safe]

log-error=/home/data/mysql/3306.err

pid-file=/home/data/mysql/mysqld.pid