编译安装mysql后添加到systemd管理

# 安装 mysql

# 准备好安装的压缩包

# 解压压缩包

tar xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar

tar xzvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

# 重命名

mv mysql-5.7.24-linux-glibc2.12-x86_64 mysql-5.7.24

# 创建用户和组

groupadd mysql

useradd -r -g mysql -s /sbin/nologin mysql

# 初始化数据目录

cd 到根目录：cd /opt/soft/mysql/mysql-5.7.24

创建数据目录：mkdir -p /opt/soft/mysql/data

初始化数据目录：./bin/mysqld --initialize --user=mysql --datadir=/opt/soft/mysql/data

记下给出的密码：&eS5eiuwJM%n

# 修改 my.cnf 配置文件

cat >> /etc/my.cnf  << EOF
[mysqld]
#default-character-set=utf8
basedir=/opt/soft/mysql/mysql-5.7.24
datadir=/opt/soft/mysql/data
socket=/tmp/mysql.sock
server-id=1
port=3306
innodb_flush_log_at_trx_commit=0
innodb_autoextend_increment=128M
innodb_log_buffer_size=20M
innodb_log_file_size=128M
innodb_buffer_pool_size=2024M
back_log=500
wait_timeout=1800
max_connections=3000
query_cache_size=50M
read_buffer_size=4M
sort_buffer_size=4M
read_rnd_buffer_size=8M
symbolic-links=0
open_files_limit  = 5000
tmp_table_size=56M
binlog_cache_size = 1M
thread_cache_size=64
log-error=/opt/soft/mysql/mysql-5.7.24/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-bin = mysql-bin
binlog_format=mixed
expire_logs_days=10
character-set-server=utf8
slow_query_log = ON
slow_query_log_file = /opt/soft/mysql/mysql-5.7.24/log/slow.log
long_query_time = 5
#slave_parallel-type=LOGICAL_CLOCK
#slave_parallel_workers=2
#master_info_repository=TABLE
#relay_log_info_repository=TABLE
#relay_log_recovery=ON
EOF

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

在 mysql.server 脚本中修改 basedir 和 datadir，确保 MySQL 服务器能够正确地找到其所需的目录和文件

cp support-files/mysql.server mysqld

sed -i '46s/basedir=/basedir=/opt/soft/mysql/mysql-5.7.24/g' /opt/soft/mysql/mysql-5.7.24/mysqld

sed -i '47s/datadir=/datadir=/opt/soft/mysql/data/g' /opt/soft/mysql/mysql-5.7.24/mysqld

# 创建刚刚在 my.cnf 中指定的日志文件

mkdir -p /opt/soft/mysql/mysql-5.7.24/log/
mkdir -p /var/run/mysqld
touch /opt/soft/mysql/mysql-5.7.24/log/mysqld.log
touch /var/run/mysqld/mysqld.pid
touch /opt/soft/mysql/mysql-5.7.24/log/slow.log
chown -R mysql:mysql /opt/soft/mysql/mysql-5.7.24
chown -R mysql:mysql /var/run/mysqld
chmod -R 750 /opt/soft/mysql/data

1
2
3
4
5
6
7
8

# 启动和登录mysql

./mysqld start

./bin/mysql -uroot -p 填入前面记录下的密码

# 修改本地管理员密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

FLUSH PRIVILEGES;

# 添加到 systemd 管理

vi /etc/systemd/system/mysql.service

[Unit]
Description=MySQL Server
Documentation=https://dev.mysql.com/doc/refman/5.7/en/
[Service]
ExecStart=/opt/soft/mysql/mysql-5.7.24/bin/mysqld_safe --defaults-file=/etc/my.cnf
User=mysql
Group=mysql
Restart=always
RestartSec=3
LimitNOFILE=infinity
[Install]
WantedBy=multi-user.target

1
2
3
4
5
6
7
8
9
10
11
12

systemctl daemon-reload

systemctl start mysql.service #启动mysql服务
systemctl enable mysql.service #设置开机自启动
systemctl disable mysql.service #停止开机自启动
systemctl status mysql.service #查看服务当前状态
systemctl restart mysql.service　 #重新启动服务
systemctl list-units --type=service #查看所有已启动的服务

1
2
3
4
5
6

# 添加软链接

保证mysql指令可用

ln -s /opt/soft/mysql/mysql-5.7.24/bin/mysql /usr/bin/mysql

# 开启防火墙端口

firewall-cmd --zone=public --add-port=3306/tcp --permanent

firewall-cmd --reload

firewall-cmd --zone=public --list-ports

#随手记录 #MySQL

← Tomcat升级防火墙笔记→