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