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;

ユーザ追加

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

ユーザ削除

# 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;