下面给你一份Linux 下 MariaDB 常见配置指南,从安装到基础安全与常用配置,适用于 CentOS / Rocky / Alma / Debian / Ubuntu 等。
sudo yum install -y mariadb-server mariadb
sudo systemctl enable --now mariadb
sudo apt update
sudo apt install -y mariadb-server
sudo systemctl enable --now mariadb
sudo mysql_secure_installation
按提示操作:
mysql -u root -p
sudo mysql
CREATE DATABASE mydb CHARACTER SET utf8mb4;
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost';
FLUSH PRIVILEGES;
允许远程连接(谨慎):
CREATE USER 'myuser'@'%' IDENTIFIED BY 'password';
GRANT ALL ON mydb.* TO 'myuser'@'%';
/etc/my.cnf
/etc/my.cnf.d/*.cnf
/etc/mysql/my.cnf
/etc/mysql/mariadb.conf.d/50-server.cnf
编辑配置文件:
[mysqld]
bind-address = 0.0.0.0
重启服务:
sudo systemctl restart mariadb
防火墙放行:
# firewalld
sudo firewall-cmd --add-port=3306/tcp --permanent
sudo firewall-cmd --reload
# ufw
sudo uflow allow 3306
[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
[client]
default-character-set = utf8mb4
[mysqld]
innodb_buffer_pool_size = 1G
max_connections = 200
[mysqld]
slow_query_log = 1
slow_query_log_file = /var/log/mariadb/slow.log
long_query_time = 2
systemctl status mariadb
日志位置:
/var/log/mariadb/mariadb.log/var/log/mysql/error.log# 重启
sudo systemctl restart mariadb
# 停止
sudo systemctl stop mariadb
# 开机自启
sudo systemctl enable mariadb
如果你有特定需求(如主从复制、Docker 部署、PHP 连接、性能调优),可以告诉我,我可以给你更针对性的配置。