centos7下mysql及redis的安装

mysql

# sudo vi /etc/yum.repos.d/MariaDB.repo
# 添加以下内容:

# MariaDB 10.3 CentOS repository list - created 2018-11-24 14:39 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
#baseurl = http://yum.mariadb.org/10.3/centos7-amd64
baseurl = http://mirrors.ustc.edu.cn/mariadb/yum/10.3/centos7-amd64
#gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgkey=http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

sudo yum install MariaDB-server MariaDB-client mariadb-devel MariaDB-shared -y

# vim /etc/my.cnf.d/server.cnf
# 在 [mysqld] 标签下方添加

init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8' 
character-set-server=utf8 
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake

# vim /etc/my.cnf.d/client.cnf
# 在 [client] 标签下方添加
default-character-set=utf8

# vim /etc/my.cnf.d/mysql-clients.cnf
# 在 [mysql] 标签下方添加
default-character-set=utf8

# 设置开机自启
sudo systemctl enable mariadb
# 启动mariadb
sudo systemctl start mariadb

mysql_secure_installation
# 初始密码为空
# 修改密码为: mysql
# 后面的设置一路yes即可
# 登录测试: mysql -uroot -p

redis

yum install redis
# 启动
redis-server & /etc/redis.conf