在CentOS7上使用yum安装MySQL 5.7

在CentOS7上使用yum安装MySQL 5.7

2017-05-08
Mysql

最近在准备团队新的开发环境,首先从配置管理做起,配置管理服务器只有一台,配置如下:

1DELL R430机架服务器
2CPU: e5-2603V4 8核
3MEM: 32G
4DISK: 2TB, raid1

团队DevOps流程所需要的多种系统都需要使用MySQL数据库,因此现在这里简单安装一个MySQL,做一下准备工作。

环境 #

  • CentOS 7.3 192.168.61.100

disable selinux

1setenforce 0
2
3vi /etc/selinux/config
4SELINUX=disabled

yum安装MySQL #

安装mysql yum repository

1wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
2
3yum localinstall mysql57-community-release-el7-11.noarch.rpm

确认yum repository已经安装

1yum repolist enabled | grep "mysql.*-community.*"
2mysql-connectors-community/x86_64       MySQL Connectors Community           36
3mysql-tools-community/x86_64            MySQL Tools Community                47
4mysql57-community/x86_64                MySQL 5.7 Community Server          187

查看MySQL版本:

 1yum repolist all | grep mysql
 2mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community    disabled
 3mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community -  disabled
 4mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community    disabled
 5mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community -  disabled
 6mysql-connectors-community/x86_64  MySQL Connectors Community     enabled:    36
 7mysql-connectors-community-source  MySQL Connectors Community - S disabled
 8mysql-tools-community/x86_64       MySQL Tools Community          enabled:    47
 9mysql-tools-community-source       MySQL Tools Community - Source disabled
10mysql-tools-preview/x86_64         MySQL Tools Preview            disabled
11mysql-tools-preview-source         MySQL Tools Preview - Source   disabled
12mysql55-community/x86_64           MySQL 5.5 Community Server     disabled
13mysql55-community-source           MySQL 5.5 Community Server - S disabled
14mysql56-community/x86_64           MySQL 5.6 Community Server     disabled
15mysql56-community-source           MySQL 5.6 Community Server - S disabled
16mysql57-community/x86_64           MySQL 5.7 Community Server     enabled:   187
17mysql57-community-source           MySQL 5.7 Community Server - S disabled
18mysql80-community/x86_64           MySQL 8.0 Community Server     disabled
19mysql80-community-source           MySQL 8.0 Community Server - S disabled

安装:

1yum install mysql-community-server

启动和配置MySQL服务 #

修改MySQL配置文件/etc/my.cnf

 1datadir=/home/mysql
 2
 3server_id = 1
 4character-set-server=utf8mb4
 5collation-server=utf8mb4_unicode_ci
 6default-storage-engine=INNODB
 7#Optimize omit
 8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
 9log-bin     = binlog
10log_bin_trust_function_creators=1
11binlog_format = ROW
12expire_logs_days = 99
13sync_binlog = 0
14slow-query-log=1
15slow-query-log-file=/var/log/mysql/slow-queries.log
16long_query_time = 3
17log-queries-not-using-indexes
18explicit_defaults_for_timestamp = 1

启动MySQL服务:

1systemctl start mysqld
2systemctl status mysqld

查看生成mysql root用户临时密码:

1grep 'temporary password' /var/log/mysqld.log

修改root用户的密码:

1mysql -uroot -p
2ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

参考 #

© 2024 青蛙小白
comments powered by Disqus