关闭防火墙
systemctl stop firewald
systemctl disable firewalld
临时禁用 SELinux(安全增强型 Linux)的强制执行模式。
setenforce 0
将 SELinux 设置为宽容模式
vi /etc/selinux/config
SELINUX=disabled
SELINUXTYPE=targeted
卸载MariaDB
rpm -qa | grep mariadb
yum -y remove mariadb-libs
1、下载MySQL安装包
cd /usr/src
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz
2、解压 MySQL压缩包
xz -d mysql-8.0.25-linux-glibc2.12-x86_64.tar.xz
tar xvf mysql-8.0.25-linux-glibc2.12-x86_64.tar
mv mysql-8.0.25-linux-glibc2.12-x86_64 /usr/local/mysql
3、创建 MySQL组和MySQL用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
4、创建MySQL相关的目录
mkdir /data/mysql/ -p
mkdir /data/mysql/{binlog,data,log,tmpdir,conf} -p
5、修改属主
chown -R mysql:mysql /data/mysql/
chown -R mysql:mysql /usr/local/mysql
6、替换该路径的my.cnf文件
vim /data/mysql/conf/my.cnf
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
## dir set
datadir = /data/mysql/data
innodb_data_home_dir = /data/mysql/data
innodb_log_group_home_dir = /data/mysql/data
log-bin = /data/mysql/binlog/mysql-bin
log_bin_index = /data/mysql/binlog/mysql-bin.index
relay-log = /data/mysql/binlog/mysql-relay-bin
tmpdir = /data/mysql/tmpdir
slow_query_log_file = /data/mysql/log/mysql-slow.log
general_log = off
general_log_file = /data/mysql/log/mysql-general.log
log-error = /data/mysql/log/mysql.err
## slave and binlog
server-id = 12161
skip-slave-start = 0
read_only = 0
binlog_format = row
log-slave-updates = 1
master_info_repository = table
relay_log_info_repository = table
relay_log_purge = 1
relay_log_recovery = 1
sync_binlog = 100
binlog_cache_size = 1M
expire_logs_days = 30
log_bin_trust_function_creators = 1
slave_net_timeout=60
#binlog_error_action="IGNORE_ERROR"
innodb_autoinc_lock_mode=1
##
back_log = 200
bulk_insert_buffer_size = 8M
#character-set-server = utf8
lower_case_table_names = 1
## 基线
local-infile = off
skip-networking = off
skip-name-resolve = on
## connect
max_allowed_packet = 32M
max_connect_errors = 1000
max_connections = 3000
wait_timeout = 3600
interactive_timeout = 3600
table_open_cache = 4096
thread_cache_size = 64
thread_stack = 192K
transaction-isolation = REPEATABLE-READ #
pid-file = mysql.pid
## slow
slow_query_log = 1
long_query_time = 1
log-slow-admin-statements
log_queries_not_using_indexes = 0
slow_launch_time = 1
read_buffer_size = 4M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 32M
tmp_table_size = 128M
max_heap_table_size = 128M
default-storage-engine = innodb
explicit_defaults_for_timestamp = on
## innodb
innodb_buffer_pool_size = 1G
innodb_max_dirty_pages_pct = 80
innodb_thread_concurrency = 8
innodb_buffer_pool_instances = 1
innodb_flush_log_at_trx_commit = 2
innodb_read_io_threads = 8
innodb_write_io_threads = 4
innodb_io_capacity = 1000
innodb_io_capacity_max = 2000
innodb_lru_scan_depth = 1024
innodb_use_native_aio = 1
innodb_flush_neighbors = 1
innodb_buffer_pool_load_at_startup = 1
innodb_buffer_pool_dump_at_shutdown = 1
innodb_data_file_path=ibdata:1G:autoextend
innodb_log_files_in_group = 3
innodb_log_file_size = 2G
innodb_file_per_table = 1
innodb_flush_method = O_DIRECT
innodb_strict_mode = 1
innodb_lock_wait_timeout = 30
innodb_log_buffer_size = 16M
innodb_adaptive_flushing = 1
innodb_change_buffering = all
innodb_purge_threads = 4
innodb_purge_batch_size = 300
innodb_old_blocks_time = 1
innodb_fast_shutdown = 0
performance_schema = 1
innodb_print_all_deadlocks = 1
innodb_sort_buffer_size = 4M
innodb_page_size = 16k
gtid_mode=on
enforce_gtid_consistency=on
table_open_cache_instances=16
binlog_rows_query_log_events=1
slave_parallel_workers = 0
#slave_parallel_type=LOGICAL_CLOCK
#binlog_group_commit_sync_delay = 500000
#binlog_group_commit_sync_no_delay_count =12
## pasword
default_password_lifetime=0
[mysqldump]
quick
max_allowed_packet = 32M
[mysql]
no-auto-rehash
prompt=\p@\d>\_
[mysqld_safe]
open-files-limit = 28192
[mysqlhotcopy]
interactive-timeout
7、初始化
/usr/local/mysql/bin/mysqld --defaults-file=/data/mysql/conf/my.cnf --user=mysql --initialize
8、获取临时密码
grep "password" /data/mysql/log/mysql.err
9、编辑
/etc/init.d/mysql.server
,修改这两行:
datadir=/data/mysql/data
confdir=/data/mysql/conf
找到
$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &
修改成
$bindir/mysqld_safe --defaults-file=$confdir/my.cnf --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &
找到
--datadir=*) datadir=`echo "$arg" | sed -e 's/^[^=]*=//'`
修改成
--datadir=*) datadir="/data/mysql/data/"
重新加载服务配置
systemctl daemon-reload
赋予权限
chmod a+wrx /etc/init.d/mysql.server
启动MySQL
/etc/init.d/mysql.server start
查看mysql是否启动
ps -ef | grep mysql
vim /etc/profile
MYSQL_HOME=/usr/local/mysql
PATH=$PATH:$MYSQL_HOME/bin
export PATH MYSQL_HOME
source /etc/profile
用临时密码登录后修改初始密码
修改初始密码
alter user user() identified by 'chenchaojie'
mysql -uroot -p'chenchaojie'