mysql 5.6 for centos_mysql5.6 for centos7.2

mysql5.6 二进制 for  centos7.2

1.系统环境(图形界面)

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

CentOS Linux release7.2.1511 (Core)

2.安装二进制包

http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36-linux-glibc2.5-x86_64.tar.gz

3.安装依赖包

yum -y install perl perl-devel autoconf libaio

4.建立MySQL用户以及组

[root@Cassandra ~]# groupadd mysql #建立mysql用户组

[root@Cassandra~]# useradd -g mysql -M -s /sbin/nologin mysql #建立mysql用户，并且将mysql加入用户组中

5.二进制源码包存放的路径/usr/local/src,解压即可

[root@Cassandra src]# tar xf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz

[root@Cassandra src]# ln-s /usr/local/src/mysql-5.6.34-linux-glibc2.5-x86_64 /usr/local/mysql

6.MySQL相关命令加载到环境变量/etc/profile

修改环境变量

[root@Cassandra local]# echo"export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

source环境变量

[root@Cassandra local]# source/etc/profile

7.建立MySQL相关用户和属组的情况

1)建立数据库日志和binlog logs存放的区域

[root@Cassandra mysql]# mkdir -p /mydata/mysql/{data,log-bin,logs,tmp}

2)建立所属主组和属组

[root@Cassandra mysql]# chown -R mysql:mysql /mydata/mysql/[root@Cassandra mysql]# chown-R mysql:mysql /usr/local/mysql

8.拷贝配置文件

设置配置文件、启动文件

[root@Cassandra support-files]# cp my-default.cnf /etc/my.cnf

[root@Cassandra support-files]# cp mysql.server /etc/init.d/mysqld

9.my.cnf配置

[client]

port = 3306

socket  =  /mydata/mysql/tmp/mysql.sock

default-character-set = utf8

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir = /usr/local/mysql

datadir = /mydata/mysql/data

port = 3306

server_id = 1

socket =  /mydata/mysql/tmp/mysql.sock

log_error = /mydata/mysql/logs/db.err

log_bin =  /mydata/mysql/log-bin/mysql-bin

pid-file =  /mydata/mysql/tmp/db.pid

character-set-server = utf8

以及初始化脚本修改

10.初始化数据库

[root@Cassandra scripts]# pwd/usr/local/mysql/scripts

[root@Cassandra scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mydata/mysql/data

11.启动数据库

[root@Cassandra ~]# service mysqld start