Backup source of MariaDB/CentOS7 (No. 1)

• Backup list
• View the diff.
• View the diff current.
• View the diff for visual.
• View the backup.
• Go to MariaDB/CentOS7.
  • 1 (2015-12-25 (Fri) 02:45:41)

- 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

** ユーザ削除 [#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;