麒麟信安二进制安装 MariaDB

版本

麒麟信安 3.4
mariadb 10.3.29

部署

# 创建用户和数据库目录
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
mkdir -p /data/mariadb/{data,logs,tmp}
chown -R mysql:mysql /data/mariadb

# 解压和初始化
cd /data/software/
wget https://archive.mariadb.org//mariadb-10.3.29/bintar-linux-systemd-x86_64/mariadb-10.3.29-linux-systemd-x86_64.tar.gz
tar zxvf mariadb-10.3.29-linux-systemd-x86_64.tar.gz 
mv mariadb-10.3.29-linux-systemd-x86_64 /usr/local/mariadb
chown -R mysql:mysql /usr/local/mariadb

cd /usr/local/mariadb
./scripts/mysql_install_db \
  --user=mysql \
  --basedir=/usr/local/mariadb \
  --datadir=/data/mariadb/data

# 检查
ls -l /data/mariadb/data/

# 创建数据库配置
cat >> /data/mariadb/my.cnf << EOF
[mysqld]
basedir = /usr/local/mariadb
datadir = /data/mariadb/data
socket  = /data/mariadb/tmp/mysql.sock
bind-address = 0.0.0.0
port    = 3306
user    = mysql
log-error = /data/mariadb/logs/mysqld.log
pid-file = /data/mariadb/tmp/mysqld.pid
tmpdir  = /data/mariadb/tmp

[client]
socket = /data/mariadb/tmp/mysql.sock
EOF

# 设置开机启动脚本
cat >> /etc/systemd/system/mariadb.service << EOF
[Unit]
Description=MariaDB Database Server
After=network.target

[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mariadb/bin/mysqld --defaults-file=/data/mariadb/my.cnf
Restart=on-failure

[Install]
WantedBy=multi-user.target
EOF

systemctl daemon-reload
systemctl start mariadb
systemctl status mariadb
systemctl enable mariadb

# 创建用户
/usr/local/mariadb/bin/mysql -h127.0.0.1 -uroot

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'klvchen123' WITH GRANT OPTION;
FLUSH PRIVILEGES;

# 检查用户和删除其余 root 用户
SELECT User, Host FROM mysql.user; 

DELETE FROM mysql.user  WHERE User='root' AND Host='127.0.0.1';
FLUSH PRIVILEGES;