centos7搭建mariadb环境

[root@localhost mariadb]# history
[root@localhost mariadb]# yum install http://rpms.famillecollet.com/enterprise/remi-release-7.rpm
[root@localhost mariadb]# yum install vim-enhanced
[root@localhost mariadb]# yum install docker
[root@localhost mariadb]# dhclient
[root@localhost mariadb]# vi /etc/sysconfig/network-scripts/ifcfg-ens33
[root@localhost mariadb]# ip addr
[root@localhost mariadb]# systemctl restart network.service
[root@localhost mariadb]# systemctl stop firewalld
[root@localhost mariadb]# systemctl disable firewalld
[root@localhost mariadb]# vi /etc/selinux/config
[root@localhost mariadb]# cat /etc/selinux/config 

[root@localhost mariadb]# rpm -qa |grep mariadb
[root@localhost mariadb]# yum remove mariadb-libs-5.5.60-1.el7_5.x86_64
[root@localhost mariadb]# vi /etc/yum.repos.d/CentOS-Media.repo 
[root@localhost mariadb]# yum install MariaDB-server MariaDB-client
[root@localhost mariadb]# mkdir -p /data/mariadb
[root@localhost mariadb]# touch mysql.sock
[root@localhost mariadb]# find / -name mysql.sock
[root@localhost mariadb]# chown -R mysql:mysql /data/mariadb
[root@localhost mariadb]# chmod -R 750 /data/mariadb
[root@localhost mariadb]# vi /etc/my.cnf.d/mysql-clients.cnf
[root@localhost mariadb]# vi /etc/my.cnf.d/server.cnf
[root@localhost mariadb]# vi /etc/selinux/config
[root@localhost mariadb]# mysql_install_db --user=mysql --datadir=/data/mariadb
[root@localhost mariadb]# service mysqld status
[root@localhost mariadb]# ps -ef|grep mariadb
[root@localhost mariadb]# vi /etc/selinux/config
[root@localhost mariadb]# systemctl start mariadb
[root@localhost mariadb]# systemctl enable mariadb
[root@localhost mariadb]# service mariadb status
[root@localhost mariadb]# service mariadb restart

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
update user set password=password('root') where user='root'; 
flush privileges; 

create user localuser@localhost identified by 'local123';
grant all on *.* to 'localuser'@'localhost' identified by 'local123';
grant all privileges on *.* to localuser@'%' identified by 'local123';

port            = 3306
datadir         = /data/mariadb
socket          = /data/mariadb/mysql.sock
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 64M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin=mysql-bin
binlog_format=mixed
server-id   = 1