Mysql-RPM-安装

数据库 , 评论

Mysql-RPM-安装

mysql5.7+centos7

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
## 卸载mysql-libs
rpm -qa |grep mysql
rpm -e mysql-libs-5.1.73-8.el6_8.x86_64 --nodeps

## 安装rpm包
rpm -ivh mysql-community-common-5.7.24-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.24-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.24-1.el6.x86_64.rpm
rpm -ivh mysql-community-server-5.7.24-1.el6.x86_64.rpm

## 启动
systemctl start mysqld
systemctl enable mysqld

## 初始化
cat /var/log/mysqld.log |grep password
mysql_secure_installation
mysql>use mysql
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123abc!!!';
mysql>flush privileges;
mysql>quit

mysql8+centos7

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
## 卸载mariadb
rpm -e $(rpm -qa |grep maria) --nodeps
yum install -y net-tools.x86_64 libaio.x86_64 perl.x86_64

## 安装rpm包
rpm -ivh mysql-community-common-8*.rpm
rpm -ivh mysql-community-client-plugins-8*.rpm
rpm -ivh mysql-community-libs-8*.rpm
rpm -ivh mysql-community-client-8*.rpm
rpm -ivh mysql-community-server-8*.rpm

## 启动
systemctl start mysqld
systemctl enable mysqld

## 初始化
cat /var/log/mysqld.log |grep password
mysql_secure_installation

mysql>use mysql
mysql>create user 'root'@'%' IDENTIFIED BY '123abc!!!';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
mysql>flush privileges;
mysql>quit

配置文件

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
[client]
default-character-set = utf8mb4
host = localhost
user = root
port = 3306
password = Hxkj2022!!!
socket=/data/mysql/mysql.sock

[mysql]
default-character-set = utf8mb4
prompt = (\\u@\\h)[\\d]\\R:\\m:\\s>
no-auto-rehash

[mysqld]
user = mysql
server-id = 1
port = 3306
datadir = /data/mysql
tmpdir = /tmp
##bind-address = 172.31.73.65
skip_name_resolve = 1
sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION '

#GTID
#gtid_mode=ON
#enforce-gtid-consistency=ON

#sync
#plugin-load-add=rpl_semi_sync_master=semisync_master.so
#rpl_semi_sync_master_enabled=1
#rpl_semi_sync_master_timeout=10000 # 10 second
binlog-ignore-db = mysql
binlog-ignore-db = sys
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema

#character
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init_connect = 'SET NAMES utf8mb4'
#lower_case_table_names = 1

#connection
back_log = 1024
max_connections = 1500
max_connect_errors = 1000000
max_allowed_packet = 128M
interactive_timeout = 1800
wait_timeout = 1800

#caches & limits
thread_cache_size = 64
key_buffer_size = 64M
join_buffer_size = 4M
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 8M
tmp_table_size = 134217728
max_heap_table_size = 134217728

log_queries_not_using_indexes = 1
log_throttle_queries_not_using_indexes=5

#innodb
innodb_file_per_table=1
innodb_thread_concurrency = 8
innodb_buffer_pool_size = 2G
innodb_log_file_size = 1G
innodb_log_buffer_size = 32M
innodb_flush_log_at_trx_commit = 0
innodb_max_dirty_pages_pct = 80
innodb_io_capacity_max = 2000
innodb_buffer_pool_instances = 10
innodb_read_ahead_threshold = 0
innodb_random_read_ahead = off
innodb_flush_neighbors = 0
sync_binlog = 0

#logging
socket=/data/mysql/mysql.sock
slow_query_log = 1
slow_query_log_file = slow.log
relay-log = mysql-relay
log_slave_updates
#log_replica_updates
long_query_time = 1
sync_binlog = 1
#log_bin = master-bin
binlog_expire_logs_seconds = 25900
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

更改默认目录

1
2
3
4
5
6
7
8
9
10
## 关闭mysql
systemctl stop mysqld

## 移动目录
mv /var/lib/mysql /data/mysql ; chown -R mysql:mysql /data/mysql

## 修改my.cnf

## 启动
systemctl restart mysqld

biglovewheat老年佛系运维

老年佛系运维 | biglovewheat@126.com