Linux Centos7 安装 mariadb

Linux Centos7 安装 mariadb

centos系统信息

[root@VM-8-10-centos ~]# uname -r
3.10.0-1127.19.1.el7.x86_64

[root@VM-8-10-centos ~]# cat /etc/os-release 
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

安装mariadb-server

yum install -y mariadb-server

关闭防火墙（非必选）

systemctl stop firewalld

开启mariadb服务并创建root用户登录密码

systemctl start mariadb
mysql_secure_installation

登录数据库，创建数据库，并授权

mysql -uroot -p
create database test charset utf8;
grant all privileges on test.* to root@'localhost' identified by '123456';
flush privileges;