mysql5.7.20二进制安装方式

1. 更换redhat源为centos源
1.1 rpm -aq|grep yum|xargs rpm -e --nodeps #卸载原有的redhat-yum程序
1.2 安装rpm_pack里面的4个包 rpm -ivh 包名+空格+包名 #安装centos的yum程序
1.3 进入/etc/yum.repos.d/并 rm -rf * #删除redhat的在线源
1.4 将yum.repos.d/里面的文件复制到 /etc/yum.repos.d/ #替换为centos在线源
1.5 yum clean all #清除yum缓存
1.6 yum makecache #生成新的yum缓存

#中间配置IP和网络及防火墙设置省略
2. 安装mysql
2.1 yum安装所需相关依赖包。
[root@DB_02 ~]# yum -y install gcc-c++
[root@DB_02 ~]# yum -y install zlib zlib-devel pcre pcre-devel
[root@DB_02 ~]# yum -y install openssl-devel
[root@DB_02 ~]#yum -y install libaio-devel.x86_64
2.2MySQL5.7 linux二进制安装

2.2.1#创建mysql的数据目录，该目录在初始化数据库的候会用到
mkdir -p /data/mysql/data
mkdir -p /data/mysql/log

2.2.2#移动mysql文件到/data/mysql/mysql
tar -zxvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz -C /data/mysql

mv mysql-5.7.20-linux-glibc2.12-x86_64 /data/mysql/mysql
2.2.3 #先创建mysql组
groupadd mysql
2.2.4#将MySQL用户加入mysql组
useradd -r -g mysql -s /bin/false mysql
2.2.5#修改目录权限
chown -R mysql:mysql /data/mysql/
2.2.6#配置my.cnf
vim /etc/my.cnf

| [client]
port = 3306
socket = /tmp/mysql.sock

[mysqld]
server_id=10
port = 3306
user = mysql
character-set-server = utf8mb4
default_storage_engine = innodb
log_timestamps = SYSTEM
socket = /tmp/mysql.sock
basedir = /data/mysql/mysql
datadir = /data/mysql/data
#pid-file = /data/mysql/data/mysql.pid
max_connections = 1000
max_connect_errors = 1000
table_open_cache = 1024
max_allowed_packet = 128M
open_files_limit = 65535
server-id=1
log-bin=mysql-bin
#####======[innodb]

#####======[log]
log_error = /data/mysql/log/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/log/mysql-slow.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES |
2.2.7#初始化数据库
在5.7.6之前初始化的方法是：bin/mysql_install_db --user=mysql
我下载的是最新的5.7.12也是4.12号刚发布的版本，5.7.6之后的版本初始化数据库不再使用mysql_install_db

/data/mysql/mysql/bin/mysqld --initialize --user=mysql --basedir=/data/mysql/mysql --datadir=/data/mysql/data --innodb_undo_tablespaces=3 --explicit_defaults_for_timestamp #初始化mysql
2.2.7#根据配置了my.cnf的error.log，查看初始密码
grep ‘password’ /data/mysql/log/mysql-error.log
2.2.8#创建ssl加密
/data/mysql/mysql/bin/mysql_ssl_rsa_setup --datadir=/data/mysql/data
2.2.9#修改目录权限
chown -R mysql:mysql /data/mysql/
2.2.10#将里面的basedir和datadir改为和my.cnf一致
vi /data/mysql/mysql/support-files/mysql.server
basedir=/data/mysql/mysql
datadir=/data/mysql/data
2.2.11#拷贝和配置启动文件
cp /data/mysql/mysql/support-files/mysql.server /etc/init.d/mysql
2.2.12设置开机启动
chkconfig --add mysql
chkconfig mysql on

2.2.13配置环境变量
mysql_home=/data/mysql/mysql
PATH=$PATH:$mysql_home/bin 临时

echo ‘PATH=/data/mysql/mysql/bin:$PATH’>>/etc/profile
tail -1 /etc/profile
source /etc/profile #让环境变量生效
echo $PATH #检查变量是否添加成功
[root@smile_DB1 init.d]# echo KaTeX parse error: Expected 'EOF', got '#' at position 112: …ysql/bin 2.2.14#̲启动mysql service…';
2.2.17#刷新权限
flush privileges;
2.2.18#查看路径信息
SHOW GLOBAL VARIABLES LIKE ‘%log%’;