学习笔记 十五： mariadb

一 mariadb简介

  它是一个关系型数据库，RHEL7后，默认安装mariadb

二 安装配置

 yum groupinstall mariadb mariadb-client -y

 systemctl start mariadb

systemctl enable mariadb

/var/log/ariadb/mariadb.log

1. mysql_secure_installation

2. configure

vi /etc/my.cnf

[mysqld]

bind-address

skip-networking

port 3306

firewall-cmd --permanent --add-service=mysql

firewall-cmd --reload

mysql -u root -h localhost -p

show databases;

create database inventory;

use inventory;

create user mobius@localhost identified by 'redhat';

select host,user,password from user where user='mobius';

grant select,update,delete,insert on inverntory.cataory  to mobius@localhost

三 案例

3.1 安装数据库mariadb，并配置安装基线和简单压力测试

本文转自 woshiwei201 51CTO博客，原文链接:http://blog.51cto.com/chenwei/1841977