Diff of MariaDB/CentOS7

• The added line is THIS COLOR.
• The deleted line is THIS COLOR.
• Go to MariaDB/CentOS7.

- http://www.unix-power.net/centos7/mariadb.html

 # yum install mariadb mariadb-server
 #  vi /etc/my.cnf
 [mysqld] の最後に
 character-set-server=utf8
 # systemctl enable mariadb.service
 # systemctl start mariadb.service

# mysql_secure_installation

# mysql -u root -p
 MariaDB [(none)]> select user,host,user from mysql.user;

** ユーザ追加 [#te65cf3d]

 # grant all on test.* to unix@localhost identified by 'password
 # grant all on test.* to unix@localhost identified by 'password'

** ユーザ削除 [#c4eca2ec]
 # MariaDB [(none)]> revoke all on test.* from unix@localhost;
 # MariaDB [(none)]> delete from mysql.user where user like 'unix' and host like 'localhost';
 # MariaDB [(none)]> flush privileges;