CentOS 从二进制版安装配置 Mariadb

# CentOS 7
mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz 

# Debian 8+, Ubuntu 15.04+
mariadb-10.2.6-linux-systemd-x86_64.tar.gz

yum -y install libaio-devel

# 删除旧的
rm -f /etc/my.cnf

# 复制新的
cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

groupadd mysql
useradd -g mysql -M -s /sbin/nologin mysql

tar -zxf mariadb-10.2.6-linux-glibc_214-x86_64.tar.gz
ln -s mariadb-10.2.6-linux-glibc_214-x86_64 mysql
cd mysql
./scripts/mysql_install_db --user=mysql
chown -R root .
chown -R mysql data

cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service start mysql

export PATH=$PATH:/usr/local/mysql/bin/
echo 'export PATH=$PATH:/usr/local/mysql/bin/' >> .bashrc
mysqld_safe --user=mysql &

/usr/local/mysql/bin/mysqladmin -u root password '新密码'
/usr/local/mysql/bin/mysqladmin -u root -h s1.dmfy.gov.cn password '新密码'
/usr/local/mysql/bin/mysql_secure_installation

mysql -uroot -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '新密码' WITH GRANT OPTION;

vim /etc/my.cnf

[client]
...
default-character-set=utf8
...
[mysql]
...
default-character-set=utf8
...
[mysqld]
...
character-set-server  = utf8
collation-server      = utf8_general_ci
character_set_server  = utf8
collation_server      = utf8_general_ci
...

mysql -uroot -p
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';