mysql 5.6.16 安装_MySQL5.6.16二进制源码安装详解及一键安装实现

一、系统环境

1.1操作系统

[root@localhost ~]# cat /etc/redhat-release

CentOS Linux release 7.4.1708 (Core)

[root@localhost ~]# uname -rm

10.0-693.el7.x86_64 x86_64

[root@localhost ~]#

1.2 安装前环境监测

1.2.1.SELinux和系统防火墙关闭

检查selinux

[root@localhost ~]# sestatus -v

SELinux status: disabled

[root@localhost ~]#

或者使用使用getenforce检查

[root@localhost ~]# getenforce

Disabled

临时关闭selinux

[root@localhost ~]# setenforce 0

setenforce: SELinux is disabled

[root@localhost ~]#

永久关闭，需要修改SELinux的配置文件/etc/selinux/config

[root@localhost ~]# vim /etc/selinux/config

This file controls the state of SELinux on the system.

SELINUX= can take one of these three values:

enforcing - SELinux security policy is enforced.

permissive - SELinux prints warnings instead of enforcing.

disabled - No SELinux policy is loaded.

SELINUX=disabled

SELINUXTYPE= can take one of three two values:

targeted - Targeted processes are protected,

minimum - Modification of targeted policy. Only selected processes are protected.

mls - Multi Level Security protection.

SELINUXTYPE=targeted

防火墙设置

查看当前防火墙状态，已经关闭，而且开机不自启动

[root@localhost ~]# systemctl status firewalld.service

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

Active: inactive (dead)

Docs: man:firewalld(1)

临时关闭

[root@localhost ~]# systemctl stop firewalld.service

永久关闭，开机不启动

[root@localhost ~]# systemctl disable firewalld.service

1.2.2.swap分区 建议不配置或者分配4GB足够

[root@localhost soft]# free -m

total used free shared buff/cache available

Mem: 1823 294 1163 9 366 1339

Swap: 2047 0 2047

1.2.3.文件系统的选择，推荐xfs(方便管理，支持动态扩容)

[root@localhost ~]# df -hT

Filesystem Type Size Used Avail Use% Mounted on

/dev/mapper/centos-root xfs 17G 5.0G 13G 29% /

devtmpfs devtmpfs 897M 0 897M 0% /dev

tmpfs tmpfs 912M 0 912M 0% /dev/shm

tmpfs tmpfs 912M 9.1M 903M 1% /run

tmpfs tmpfs 912M 0 912M 0% /sys/fs/cgroup

/dev/sda1 xfs 1014M 179M 836M 18% /boot

tmpfs tmpfs 183M 12K 183M 1% /run/user/42

tmpfs tmpfs 183M 0 183M 0% /run/user/0

1.2.4.操作系统限制(ulimit -a查看 主要参数open files max user processes )

[root@localhost ~]# ulimit -a

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 7168

max locked memory (kbytes, -l) 64

max memory size (kbytes, -m) unlimited

open files (-n) 1024

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 8192

cpu time (seconds, -t) unlimited

max user processes (-u) 7168

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

二、开始安装MySQL5.6版本

2.1安装准备

(1)软件版本:5.6.16

(2)安装方式：二进制方式 方便、灵活、管理数据和配置文件便捷

其他安装方式：rpm安装、yum安装

(3)硬件需求：虚拟机内存大小：最少2G

磁盘最少：40G

(4)系统环境：Centos6/7 Redhat 64位

安装包管理在/opt/目录下创建/opt/soft，在官网下载mysql安装包，通过secureCRT或者xshell并上传安装包到此目录。

[root@localhost ~]# ll /opt/soft/

total 297656

rw-r--r-- 1 root root 3222 Mar 22 16:59 my.cnf

rw-r--r-- 1 root root 304788904 Mar 13 20:30 mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz

rw-r--r-- 1 root root 2032 May 11 23:35 mysql_install_binary5.6.16.sh

2.2手动安装步骤如下

2.2.1三部曲

=>创建家目录:(basedir)，并授权

/usr/local

解压mysql安装包到家目录 改名称(隐藏版本号)

[root@localhost soft]# tar -zxvf mysql-5.6.16-linux-glibc2.5-x86_64.tar.gz -C /usr/local/

[root@localhost soft]# ll -d /usr/local/mysql*

lrwxrwxrwx 1 root root 46 May 15 09:09 /usr/local/mysql -> /usr/local/mysql-5.6.16-linux-glibc2.5-x86_64/

drwxr-xr-x 13 root root 213 May 15 09:06 /usr/local/mysql-5.6.16-linux-glibc2.5-x86_64

[root@localhost soft]#

授权mysql家目录给mysql用户

[root@localhost soft]# id mysql

uid=27(mysql) gid=27(mysql) groups=27(mysql)

如果没有MySQL用户，可以创建mysql用户授权并查看

[root@localhost soft]# chown -R mysql:mysql /usr/local/mysql

[root@localhost soft]# ll -d /usr/local/mysql

lrwxrwxrwx 1 mysql mysql 46 May 15 09:09 /usr/local/mysql -> /usr/local/mysql-5.6.16-linux-glibc2.5-x86_64/

2曲=>创建数据目录(datadir)，并授权

/data/mysql/

授权数据目录给mysql用户

[root@localhost soft]# mkdir -p /data/mysql

[root@localhost soft]# ll -ld /data/mysql/

drwxr-xr-x 2 root root 6 May 15 09:13 /data/mysql/

[root@localhost soft]# chown -R mysql:mysql /data/mysql/

[root@localhost soft]# ll -ld /data/mysql/

drwxr-xr-x 2 mysql mysql 6 May 15 09:13 /data/mysql/