Install MariaDB

1.yum install mariadb-server mariadb

2.systemctl enable mariadb; systemctl start mariadb

3.mysql_secure_installation

4.mysql -u root -p mysql -e "SELECT User,Host FROM user"

5.mysql -u root -p

6.CREATE DATABASE db1 CHARACTER SET utf8 COLLATE utf8_general_ci;

7.SHOW DATABASES;

8.GRANT ALL ON db1.* to 'user1'@'localhost' IDENTIFIED BY 'redhat' WITH GRANT OPTION;

9.FLUSH PRIVILEGES;

10.EXIT

11.mysql -u user1 -p

12.SHOW DATABASES;

note:

1. DROP DATABASE IF EXISTS db2;

2. GRANT ALL ON *.* TO 'user2'@'localhost' IDENTIFIED BY 'redhat' WITH GRANT OPTION;

3. SELECT HOST,USER FROM mysql.user WHERE USER='user1';

4. SHOW GRANTS FOR 'user2'@'localhost';

5. DROP USER 'user3'@'localhost';

6. Allowing remote access to a MariaDB server:

    1. firewall-cmd --permanent --add-service=mysql && firewall-cmd --reload

    2. GRANT SELECT ON mysql.user TO 'joh'@'192.168.1.2' IDENTIFIED BY 'openbsd';

    3. FLUSH PRIVILEGES; EXIT;

    4. mysql -u joh -p -h 192.168.1.1 mysql