centos mysql 5.6.20_centos 7 min 编译安装mysql5.6.20 笔记

1.首先添加依赖应用

yum install -y gcc gcc-c++ autoconf automake zlib* libxml*  libtool-ltdl-devel*

2.安装 cmake 及相关软件 ncurses 和 bison

wget http://www.cmake.org/files/v3.0/cmake-3.0.2.tar.gz

tar zxvf cmake-3.0.2.tar.gz

cd cmake-3.0.2

./bootstrap

make

make install

yum install -y ncurses-devel*

yum install -y bison

3.创建 mysql 用户， 创建数据库目录和权限

groupadd mysql

useradd -g mysql mysql

mkdir -p  /data/mysql

chown -R root:mysql /data/mysql

4.下载 mysql 源码并且编译

wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.20.tar.gz

tar xzfv mysql-5.6.20.tar.gz

cd mysql-5.6.20

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc/

gmake

gmake install

5.配置 mysql

cd /usr/local/mysql

cp ./support-files/my-default.cnf /etc/my.cnf

vim /etc/my.cnf

在 [mysqld] 段增加

datadir = /data/mysql

wait-timeout = 30

max_connections = 512

max_connect_errors = 10000000

default-storage-engine = MyISAM

在 [mysqld] 段修改

max_allowed_packet = 16M

然后保存退出编辑

初始化数据库

./scripts/mysql_install_db --datadir=/data/mysql --basedir=/usr/local/mysql  --defaults-file=/etc/my.cnf --user=mysql

cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld

chmod 755 /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

设置启动脚本变量

编辑 /etc/rc.d/init.d/mysqld

vim /etc/rc.d/init.d/mysqld

basedir=/usr/local/mysql

datadir=/data/mysql

设置变量环境

#echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile (永久生效)

# export PATH=$PATH:/usr/local/mysql/bin (当前生效)

cd bin

启动服务

service mysqld start

设置数据库管理员root密码

mysqladmin -u root password '123456'

service mysqld restart

进入Mysql