国产系统安装MariaDB数据库步骤

1. 通过yum安装

# 先更新一下

yum upgrade

# 安装

yum -y install mariadb mariadb-server

# 启动服务

systemctl start mariadb

2. 进行基本选项配置

mysql_secure_installation

直接按回车键进行数据库初始密码的设置；（一路yes下去）



3. 编码配置（重点）

# 编辑/etc/my.cnf

vim /etc/my.cnf



# 在[mysqld]标签下添加下面内容

default-storage-engine = innodb

innodb_file_per_table

max_connections = 4096

collation-server = utf8_general_ci

character-set-server = utf8



# 编辑/etc/my.cnf.d/client.cnf

vim /etc/my.cnf.d/client.cnf



# 在[client]标签下添加下面内容

default-character-set=utf8



# 编辑/etc/my.cnf.d/mysql-clients.cnf

vim /etc/my.cnf.d/mysql-clients.cnf



# 在[mysql]标签下添加下面内容

default-character-set=utf8

4. 重启服务

systemctl restart mariadb

# 设置开机自启动

systemctl enable mariadb

5. 设置数据库远程连接权限

创建前要先登录root



mysql -uroot -ppassword;

us mysql;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION;

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

flush privileges;