CentOS6u9 使用Mariadb官方yum源安装最新Stable版本命令简录

根据官档配置yum源：

以下来自官网文档：https://downloads.mariadb.org/mariadb/repositories/

cat >/etc/yum.repos.d/mariadb.repo<<EOF
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF

镜像加速：

安装所需的RPM包较大，建议使用国内镜像进行优化，如使用中国科学技术大学开源镜像：http://mirrors.ustc.edu.cn/

查看帮助页，获取信息：

根据提示，修改yum源配置文件：

sed -i 's#yum\.mariadb\.org#mirrors.ustc.edu.cn/mariadb/yum#' /etc/yum.repos.d/mariadb.repo
sed -i 's#http://mirrors\.ustc\.edu\.cn#https://mirrors.ustc.edu.cn#g' /etc/yum.repos.d/mariadb.repo
# 注意，页面上的 /etc/yum.repos.d/mariadb 只是对配置文件的举例
# 实际上此处有笔误，yum的配置文件应该以.repo为后缀，如 /etc/yum.repos.d/XXXX.repo

安装配置：

yum -y install MariaDB-client MariaDB-server

cat >>/etc/my.cnf<<EOF
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
EOF

chkconfig mysql on
/etc/init.d/mysql start

PASS=vincent
mysqladmin -u root password "$PASS"
echo "GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' \
    IDENTIFIED BY '$PASS' WITH GRANT OPTION;"|\
    mysql -uroot -p"$PASS" -Dmysql
echo "GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' \
    IDENTIFIED BY '$PASS' WITH GRANT OPTION;"|\
    mysql -uroot -p"$PASS" -Dmysql
echo "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' \
    IDENTIFIED BY '$PASS' WITH GRANT OPTION;"|\
    mysql -uroot -p"$PASS" -Dmysql
echo "update user set password=password('$PASS') where user='root';"|\
    mysql -uroot -p"$PASS" -Dmysql
echo "delete from user where not (user='root') ;"|\
    mysql -uroot -p"$PASS" -Dmysql
echo "delete from user where user='root' and password=''; "|\
    mysql -uroot -p"$PASS" -Dmysql
echo "drop database test;"| mysql -uroot -p"$PASS" -Dmysql
echo "DROP USER ''@'%';"  | mysql -uroot -p"$PASS" -Dmysql
echo "flush privileges;"  | mysql -uroot -p"$PASS" -Dmysql

[TOC]