Linux Centos7 安装 mariadb
centos系统信息
[root@VM-8-10-centos ~]
3.10.0-1127.19.1.el7.x86_64
[root@VM-8-10-centos ~]
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;