centos mysql 5.6 源码_Centos mysql 5.6.26 源码安装

1.下载mysql

http://www.mysql.com/downloads/ -> MySQL Community Edition (GPL) -> MySQL Community Server (GPL) -> Select Platform选择source code -> Generic Linux (Architecture Independent), Compressed TAR Archive -> Download -> Generic Linux (Architecture Independent), Compressed TAR Archive

2. 安装依赖包(先试试能不能后续步骤，在酌情添加)

yum -y install make gcc-c++ cmake bison-devel ncurses-devel

yum install -y gcc gcc-c++ kernel-devel

yum install -y readline-devel pcre-devel openssl-devel openssl zlib zlib-devel pcre-devel

3. 解压下载的tar包

tar -xvf mysql-5.6.26.tar #在这里我解压到了 /share/workdir/yangl／mysql-5.6.26

4 安装

4.1 编译源码(mysql5.5以后是通过cmake来编译的)

mv /share/workdir/yangl／mysql-5.6.26／* /share/soft/mysql #复制到我的安装目录/share/soft/mysql

cmake \

-DCMAKE_INSTALL_PREFIX=/share/soft/mysql/ \

-DMYSQL_DATADIR=/share/soft/mysql/data/ \

-DSYSCONFDIR=/etc \

-DWITH_MYISAM_STORAGE_ENGINE=1 \

-DWITH_INNOBASE_STORAGE_ENGINE=1 \

-DWITH_MEMORY_STORAGE_ENGINE=1 \

-DWITH_READLINE=1 \

-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \

-DMYSQL_TCP_PORT=3306 \

-DENABLED_LOCAL_INFILE=1 \

-DWITH_PARTITION_STORAGE_ENGINE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci

make

make install

4.2 创建mysql用户

groupadd mysql

useradd -r -g mysql mysql

4.3 修改目录权限

cd mysql

chown -R mysql .

chgrp -R mysql .

4.4 正式安装和配置mysql-安装mysql运行所需的内置数据库(橙黄色部分是为安装OrthoMCl所需的特殊的mysql配置安装方法，非准OrthoMCL用户请忽略橙黄色部分)

./scripts/mysql_install_db –user=mysql

(./scripts/mysql_install_db –defaults-file=mysql.cnf –user=mysql ＃mysql.cnf已经set basedir 和 set datadir,并修改内存分配)

4.5  修改权限(收回权限)

chown -R root .

chown -R mysql data

4.6 打开后台程序(手动启动mysql)

bin/mysqld_safe –user=mysql &

(./bin/mysqld_safe –defaults-file=mysql.cnf & )

4.7 设置root密码

/share/soft/mysql/bin/mysqladmin -u root password ‘123456’

(/share/soft/mysql/bin/mysqladmin –defaults-file=mysql.cnf -u root password “123456”)

5  设置环境变量

ln -s /share/soft/mysql/bin/mysql /usr/bin/ #现在，我们可以在终端内直接输入mysql进入，mysql的环境了

到此，mysql安装完成。