Linux之mariadb数据库的安装使用

标题数据库软件的介绍

MariaDB数据库管理系统由MySQL项目创始者重新研发
MariaDB由开源社区进行维护，不受商业专利限制
MariaDB和MySQL在性能上基本保持一致，两者的操作命令也十分相似
相较于MySQL，MariaDB数据库管理系统有了很多新鲜的扩展特性，例如对微秒级别的支持、线程池、子查询优化、进程报告等

安装mariadb软件并设置服务开启等配置

安装mariadb软件
yum install mariadb-server.x86_64 -y

开启mariadb服务

查看防火墙的状态

初始化数据库mysql_secure_installation

[root@192 ~]# mysql_secure_installation 

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ..