CentOS7安装MariaDB

1.下载安装包

下载systemd包到/vdb路径
mariadb-10.4.12-linux-systemd-x86_64.tar.gz

2.用户配置

tar -zxvf mariadb-10.4.12-linux-systemd-x86_64.tar.gz -C /vdb

groupadd mysql
useradd -r -g mysql mysql

3.初始化

cd /vdb/mariadb-10.4.12/scripts
./mysql_install_db --basedir=/vdb/mariadb-10.4.12 --datadir=/vdb/mariadb-10.4.12/data --user=mysql

mkdir /vdb/mariadb-10.4.12/log

4.生成配置文件

vi /vdb/mariadb-10.4.12/my.cnf

[mysqld]
basedir=/vdb/mariadb-10.4.12
datadir=/vdb/mariadb-10.4.12/data
port=3306
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
max_connections=100
query_cache_size=0
innodb_strict_mode = 0
innodb_file_per_table=1
innodb_buffer_pool_size=2047M
innodb_log_file_size=50M
max_allowed_packet = 500M
character-set-server=utf8
log-bin=/vdb/mariadb-10.4.12/log/mysql-bin
log_bin_index=/vdb/mariadb-10.4.12/log/mysql-bin.index
log_bin_trust_function_creators=1
binlog_format=mixed
expire_logs_days=7
max_binlog_size=100m
binlog_cache_size=4m
max_binlog_cache_size=512m
[client]
port=3306
plugin-dir=/vdb/mariadb-10.4.12/lib/plugin

5.MariaDB配置

cp /vdb/mariadb-10.4.12/my.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysql
cp support-files/mysql.server /etc/rc.d/init.d/mysql
chmod 755 /etc/init.d/mysql
chkconfig --level 2345 mysql on

chown -R mysql:mysql /vdb/mariadb-10.4.12

6.防火墙

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

其他命令

systemctl status mysql.service
systemctl daemon-reload
/etc/init.d/mysql start

密码及权限配置

/vdb/mariadb-10.4.12/bin/mysql -uroot -p
use mysql
ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("123456");
grant all privileges on *.* to root@'%' identified VIA mysql_native_password USING PASSWORD("123456");
flush privileges;