micro service system configuration(2)-CMP配置中心

1.配置yum源

vi/etc/yum.repos.d/mariadb.repo

[mariadb] name = MariaDBbaseurl = https://mirrors.ustc.edu.cn/mariadb/yum/10.2/centos7-amd64gpgkey=https://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB gpgcheck=1

2.yum安装

yum -yinstall MariaDB-server MariaDB-client

3.启动服务

systemctlstart mariadb

4.设置开机启动

systemctlenable mariadb

5.设置密码

mysql_secure_installation

6.配置字符集

客户端：vi/etc/my.cnf.d/mysql-clients.cnf

[mysql]default-character-set=utf8

服务端：vi/etc/my.cnf.d/server.cnf

[mysqld] init_connect='SETcollation_connection = utf8_general_ci' init_connect='SET NAMES utf8'character-set-server=utf8 collation-server=utf8_general_ciskip-character-set-client-handshake #开启慢查询 slow_query_log= ON slow_query_log_file = /usr/local/mysql/data/slow.log long_query_time = 1

7.重启

systemctlrestart mariadb

8.设置root可远程连接

mysql -uroot-y

GRANT ALL PRIVILEGES ON *.* TO'root'@'%'IDENTIFIED BY '1qazxsw2' WITH GRANT