根据官档配置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]