标签：mnt server zabbix mysql root rhd msyql5.7
mysql5.7
下载二进制
# 下载
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
创建数据库用户
[root@zabbix-server ~]# groupadd -r mysql
[root@zabbix-server ~]# useradd -r -g mysql -M -s /bin/false mysql
解压安装
[root@zabbix-server ~]# tar -zxf /root/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@zabbix-server ~]# mkdir /mnt/rhd
[root@zabbix-server ~]# mv mysql-5.7.22-linux-glibc2.12-x86_64 /mnt/rhd/mysql
[root@zabbix-server ~]# ln -s /mnt/rhd/mysql/bin/* /usr/local/bin/
创建所需目录
[root@zabbix-server ~]# mkdir /mnt/rhd/mysql/conf
[root@zabbix-server ~]# mkdir /mnt/rhd/mysql/data
[root@zabbix-server ~]# mkdir /mnt/rhd/mysql/dbbak
[root@zabbix-server ~]# mkdir /mnt/rhd/mysql/logs
[root@zabbix-server ~]# mkdir /mnt/rhd/mysql/redo
[root@zabbix-server ~]# mkdir /mnt/rhd/mysql/undo
[root@zabbix-server ~]# chown -R mysql.mysql /mnt/rhd/mysql
systemctl管理
[root@zabbix-server ~]#cat > /usr/lib/systemd/system/mysqld.service <<EOF
[Unit]
Description=MySQL Server
After=network.target
[Install]
WantedBy=multi-user.target
[Service]
Type=simple
PrivateNetwork=false
User=mysql
Group=mysql
CapabilityBoundingSet=CAP_IPC_LOCK
ProtectSystem=full
PrivateDevices=true
ProtectHome=true
PermissionsStartOnly=true
PIDFile=/mnt/rhd/mysql/data/mysql.pid
ExecStart=/mnt/rhd/mysql/bin/mysqld_safe --defaultsfile=/mnt/rhd/mysql/conf/my.cnf --user=mysql
ExecStop=/bin/kill -9 $MAINPID
KillSignal=SIGTERM
SendSIGKILL=no
Restart=on-abort
RestartSec=5s
UMask=007
PrivateTmp=false
TimeoutStartSec=900
TimeoutStopSec=900
LimitNOFILE=16384
EOF
# 重载
[root@zabbix-server ~]# systemctl daemon-reload
# 删除centos7中自带的mariadb-libs
[root@zabbix-server ~]# rpm -e mariadb-libs --nodeps
编辑配置文件
[root@zabbix-server ~]# cat>/mnt/rhd/mysql/conf/my.cnf <<EOF
#[client]
#socket=/mnt/rhd/mysql/mysql.sock
#[mysqld]
#basedir=/mnt/rhd/mysql
#datadir=/mnt/rhd/mysql/data
#pid-file=/mnt/rhd/mysql/data/mysql.pid
#socket=/mnt/rhd/mysql/mysql.sock
#log-error=/mnt/rhd/mysql/data/mysql.err
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
[client]
port = 3316
socket = /mnt/rhd/mysql/logs/mysql.sock
[mysqld]
explicit_defaults_for_timestamp=true
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DAT
E,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
port = 3316
basedir = /mnt/rhd/mysql
datadir = /mnt/rhd/mysql/data
server_id = 803316
socket = /mnt/rhd/mysql/logs/mysql.sock
back_log = 350
connect_timeout = 20
event_scheduler = off
local_infile = off
secure_file_priv = /mnt/rhd/mysql/dbbak
pid-file = /mnt/rhd/mysql/data/mysql.pid
wait_timeout = 1800
interactive_timeout =1800
character_set_server = utf8mb4
skip_name_resolve
log_timestamps=system
skip-ssl
disable-partition-engine-check
#skip_grant_tables
#innodb_force_recovery=6
######### bin log ####################
#binlog_format = row
#binlog_row_image = full
#binlog_cache_size = 2M
#max_binlog_size = 1G
#max_binlog_cache_size = 4G
#binlog_rows_query_log_events = 0
#master_verify_checksum = 1
#slave_allow_batching = 1
#expire_logs_days = 7
#log-bin =/mnt/rhd/mysql/logs/mysql_bin
######### error log ####################
#log_warnings = 2
log_error = /mnt/rhd/mysql/logs/error.log
log_syslog
log_syslog_tag = 3316
########## general_log ####################
#general_log_file = /mnt/rhd/mysql/logs/general.log
########## slow log ####################
long_query_time = 1
slow_query_log = on
log_queries_not_using_indexes = off
#log_slow_admin_statements = on
slow_query_log_file = /mnt/rhd/mysql/logs/slow.log
skip_slave_start
read_only = off
slave_parallel_type = logical_clock
slave_parallel_workers = 4
relay_log_info_repository = TABLE
master_info_repository = TABLE
relay_log_recovery = on
sync_master_info = 10000
slave_compressed_protocol = off
slave_net_timeout = 10
#log_slave_updates
#relay_log=/mnt/rhd/mysql/logs/relay_bin
#auto-increment-increment = 2
#auto-increment-offset = 2
#slave_skip_errors = all
#slave-skip-errors=1064 1146 1062
#rpl_semi_sync_master_enabled = ON
#rpl_semi_sync_slave_enabled = ON
#rpl_semi_sync_master_timeout = 10000
gtid_mode = ON
enforce_gtid_consistency = ON
relay_log_purge=0
#replicate_wild_ignore_table =mysql.%
#replicate_wild_ignore_table =information_schema.%
#replicate_wild_ignore_table =performance_scheme.%
#replicate_wild_ignore_table =sys.%
#replicate_wild_ignore_table =percona.%
########### innodb ####################
default_storage_engine = InnoDB
#innodb_buffer_pool_size = 32G
#innodb_buffer_pool_instances = 8
#innodb_data_home_dir = /mnt/rhd/mysql/data/
#innodb_data_file_path = ibdata1:1000M;ibdata2:100M:autoextend
#innodb_log_group_home_dir = /mnt/rhd/mysql/redo/
#innodb_log_files_in_group = 3
#innodb_log_file_size = 256M
#innodb_log_buffer_size = 8M
#innodb_lock_wait_timeout = 40
#innodb_file_per_table = 1
#innodb_stats_on_metadata = OFF
lower_case_table_names = 1
#innodb_flush_method = O_DIRECT
#innodb_flush_log_at_trx_commit = 0
log_bin_trust_function_creators = 1
sync_binlog = 1
#innodb_open_files = 1024
#innodb_thread_concurrency = 0
#innodb_print_all_deadlocks = ON
performance_schema = ON
innodb_undo_log_truncate = 1
innodb_undo_tablespaces = 3
innodb_rollback_segments = 128
innodb_max_undo_log_size = 1073741824
innodb_undo_directory = /mnt/rhd/mysql/undo/
#innodb_purge_threads = 1
##innodb_write_io_threads = 4
##innodb_read_io_threads = 4
#thread_pool
#thread_handling =pool-of-threads
#thread_pool_stall_limit =10
#########for SSD ###################
innodb_io_capacity = 200
innodb_adaptive_flushing = OFF
innodb_flush_neighbors = 2
innodb_page_cleaners=8
innodb_lru_scan_depth=256
innodb_max_dirty_pages_pct=50
innodb_max_dirty_pages_pct_lwm=0
#########per_thread_buffers####################
max_connections = 3000
max_connect_errors = 2048
max_allowed_packet = 32M
max_heap_table_size = 256M
tmp_table_size = 256M
max_prepared_stmt_count = 1M
query_alloc_block_size = 128K
query_cache_limit = 0
query_cache_size = 0
join_buffer_size = 512k
key_buffer_size = 1M
query_cache_type = 0
query_prealloc_size = 64K
read_buffer_size = 1M
read_rnd_buffer_size = 512K
sort_buffer_size = 2M
table_open_cache = 2048
table_open_cache_instances= 8
thread_cache_size = 128
group_concat_max_len = 2048
skip-external-locking
#myisam
#myisam_recover_options=BACKUP,FORCE
#key_buffer_size=2G
[mysqldump]
max_allowed_packet = 32M
EOF
初始化并修改密码
### mysql初始化
[root@zabbix-server ~]# mysqld --initialize --user=mysql --basedir=/mnt/rhd/mysql/ --datadir=/mnt/rhd/mysql/data
#执行完会出现一大片英文，看不懂没关系，在最后面看到有一个 root@localhost: 后面有一连串的字母
数字符号, 这是 MySQL 为你自动生成的随机密码. 要记下来, root就是登陆的用户名，一会我们登陆
MySQL 数据库的时候要用
### 服务启动 并修改密码为123.com
systemctl restart mysqld
mysqlpwd=刚才初始化是自动生成的密码
mysql -uroot -p${mysqlpwd} -S /mnt/rhd/mysql/logs/mysql.sock -e 'alter user root@localhost identified by"123.com"' --connect-expired-password
### 登录测试
[root@zabbix-server ~]# mysql -u root -p -S /mnt/rhd/mysql/logs/mysql.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.22-log MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
创建用户
### 创建zabbix用户
mysql> create database zabbix character set utf8 collate utf8_bin;
Query OK, 1 row affected (0.00 sec)
mysql> create user zabbix@localhost identified by 'zabbix';
Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'zabbix';
Query OK, 0 rows affected, 1 warning (0.01 sec)
导入数据
#因为我们这里是恢复以前的数据库，所以导入数据库即可
mysql> use zabbix
mysql> source /mnt/rhd/mnt/rhd/mysql_dbbak/20220721/zabbix_4.sql;
#如果没有上面的备份，安装zabbix-server-mysql后有相关的sql导入即可，例如：
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix
标签：mnt,
server,
zabbix,
mysql,
root,
rhd,
msyql5.7
From： https://www.cnblogs.com/kkit/p/18348529