mysql5.6 for centos7.2

 

mysql5.6 二进制 for  centos7.2

1.系统环境（图形界面）

[root@Cassandra ~]# cat  /etc/redhat-release 
CentOS Linux release 7.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