由于MysqL已经有闭源的趋势,所以大部分系统已经不建议使用MysqL,Mariadb是MysqL之父创建的一个MysqL分支项目,使用起来几乎一模一样。
1.安装MariaDB
# yum install mariadb-server mariadb-client
2.运行数据库
# systemctl start mariadb
# MysqL
# MariaDB [(none)]> create database production;
# MariaDB [(none)]> use production;
# MariaDB [(none)]> flush privileges;
# MariaDB [(none)]> create user 'test1'@'%' identified by 'test1';
# MariaDB [(none)]> grant all privileges on production.* to test1 identified by 'test1';
# MariaDB [(none)]> flush privileges;
# MysqL -u test1 -p
Enter password: test1
6.登陆成功!
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 214
Server version: 5.5.52-MariaDB MariaDB Server
Copyright (c) 2000,2016,Oracle,MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
原文链接:https://www.f2er.com/centos/378763.html