centos 7.0 编译 安装mysql 5.6.22 过程 已完成~ 成功~ 撒花~

mysql 下载目录/usr/local/src
mysql 解压目录 /usr/local/bin/mysql

GitHub https://github.com/mysql/mysql-server

mysql官网的安装说明
http://dev.mysql.com/doc/refman/5.6/en/source-installation.html

安装mysql必须的要求
CMake make3.75以上 GCC 4.2.1以上 Perl
Curses ncurses-devel

最新3.1.1 cmake 安装

http://www.cmake.org/

下载页面
http://www.cmake.org/download/

下载目录/usr/local/src
wget http://www.cmake.org/files/v3.1/cmake-3.1.1.tar.gz

解压目录 /usr/local/bin/cmake-3.1.1

进入解压目录
[root@localhost src]# cd /usr/local/bin/cmake-3.1.1
[root@localhost cmake-3.1.1]# ls
Auxiliary CompileFlags.cmake Help
bootstrap configure Licenses
CMakeCPack.cmake CONTRIBUTING.rst Modules
CMakeCPackOptions.cmake.in Copyright.txt README.rst
CMakeGraphVizOptions.cmake CTestConfig.cmake Source
CMakeLists.txt CTestCustom.cmake.in Templates
CMakeLogo.gif DartConfig.cmake Tests
cmake_uninstall.cmake.in doxygen.config Utilities

[root@localhost cmake-3.1.1]./bootstrap
[root@localhost cmake-3.1.1]make
[root@localhost cmake-3.1.1]make install

Make 4.1安装

http://www.gnu.org/software/make/
下载
wget http://ftp.gnu.org/gnu/make/make-4.1.tar.gz

解压

[root@localhost make-4.1]./configure
[root@localhost make-4.1]make
[root@localhost make-4.1]make install

安装 M4

http://www.gnu.org/software/m4/

下载
wget http://ftp.gnu.org/gnu/m4/m4-latest.tar.gz

[root@localhost src]# wget http://ftp.gnu.org/gnu/m4/m4-latest.tar.gz
--2015-01-28 11:37:14-- http://ftp.gnu.org/gnu/m4/m4-latest.tar.gz
正在解析主机 ftp.gnu.org (ftp.gnu.org)... 208.118.235.20, 2001:4830:134:3::b
正在连接 ftp.gnu.org (ftp.gnu.org)|208.118.235.20|:80... 已连接。
已发出 HTTP 请求，正在等待回应... 200 OK
长度：1820658 (1.7M) [application/x-gzip]
正在保存至: “m4-latest.tar.gz”

100%[======================================>] 1,820,658 40.8KB/s 用时 42s

2015-01-28 11:37:57 (42.6 KB/s) - 已保存 “m4-latest.tar.gz” [1820658/1820658])

解压
[root@localhost src]# tar zxvf m4-latest.tar.gz -C /usr/local/bin

cd /usr/local/bin/m4-1.4.17

[root@localhost ~]# cd /usr/local/bin/m4-1.4.17
[root@localhost m4-1.4.17]# ls
acinclude.m4 build-aux configure GNUmakefile Makefile.am tests
aclocal.m4 c-boxes.el configure.ac INSTALL Makefile.in THANKS
AUTHORS cfg.mk COPYING lib NEWS TODO
BACKLOG ChangeLog doc m4 README
bootstrap checks examples maint.mk src

[root@localhost ~]./configure
[root@localhost ~]make
[root@localhost ~]make install

Bison 3.0.4

http://www.gnu.org/software/bison/

http://ftp.gnu.org/gnu/bison/

下载
wget http://ftp.gnu.org/gnu/bison/bison-3.0.4.tar.gz

解压
tar zxvf bison-3.0.4.tar.gz -C /usr/local/bin

[root@localhost src]# tar zxvf bison-3.0.4.tar.gz -C /usr/local/bin

[root@localhost src]# cd /usr/local/bin/bison-3.0.4
[root@localhost bison-3.0.4]# ls
ABOUT-NLS ChangeLog-1998 djgpp lib PACKAGING src
aclocal.m4 ChangeLog-2012 doc m4 po tests
AUTHORS configure etc maint.mk README THANKS
build-aux configure.ac examples Makefile.am README-alpha TODO
cfg.mk COPYING GNUmakefile Makefile.in README-release
ChangeLog data INSTALL NEWS runtime-po

这里必须安装M4 在运行
[root@localhost bison-3.0.4]./configure

[root@localhost bison-3.0.4]make
[root@localhost bison-3.0.4]make install

ncurses-devel (RPM安装)

找到两个网址下载 随便来一个吧
http://pkgs.org/download/ncurses-devel
http://rpmfind.net/linux/rpm2html/search.php?query=ncurses-devel

下载
wget ftp://rpmfind.net/linux/centos/7.0.1406/os/x86_64/Packages/ncurses-devel-5.9-13.20130511.el7.x86_64.rpm

安装或者升级一个rpm包
rpm -ivh rpm文件【安装】
rpm -Uvh rpm文件【更新】

安装 mysql 5.66.22

遇到了不少问题 感觉最好的办法就是重新装一遍 记得cmake以前删除CMakeCache.txt

[root@localhost src]wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.22.tar.gz
解压
[root@localhost src]tar zxvf mysql-5.6.22.tar.gz -C /usr/local/bin
进入目录

这个图是后来从新编译的 就看下编译选项就好了

执行的命令

再次编译 改了下配置文件的位置 红色字体

[root@localhost mysql-5.6.22]# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/etc/mysql \
-DMYSQL_DATADIR=/usr/etc/mysql/data \
-DSYSCONFDIR=/usr/etc/mysql \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_HEAP_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/usr/etc/mysql/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS:STRING=utf8,gbk \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
[root@localhost mysql-5.6.22]make

[root@localhost mysql-5.6.22]make install

进入安装目录

初始化数据库

资料引用

初始化安装 官网介绍 mysql_install_db
http://dev.mysql.com/doc/refman/5.6/en/unix-postinstallation.html

http://dev.mysql.com/doc/refman/5.6/en/postinstallation.html

http://www.cnblogs.com/xiongpq/p/3384681.html

./mysql_install_db --user=mysql --basedir=/usr/etc/mysql --datadir=/usr/etc/mysql/data
最主要要定义

--basedir 安装目录

--datadir 数据存放目录

上面的警告 应该都能读懂 如果在/etc下有my.cnf文件 就是优先加载这个配置 所以就删除吧

rm -f my.cnf

删除默认/etc/my.cnf
cd /etc/
rm -f my.cnf

编辑安装目录下的配置文件/usr/etc/mysql/my.cnf

# These are commonly set, remove the # and set as required.
basedir = /usr/etc/mysql
datadir = /usr/etc/mysql/data
port = 3306
# server_id = .....
# socket = .....

参考 http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

---

添加用户mysql

[root@localhost data]# useradd mysql

[root@localhost data]# groupadd mysql
groupadd：“mysql”组已存在

给安装目录权限

先给权限 要不然mysql 无法正常启动

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

复制mysql.server到启动目录init.d
[root@localhost mysql]# cp support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql]# chkconfig mysql on

启动mysql

[root@localhost data]# service mysql start
Starting MySQL. SUCCESS!

启动成功

[root@localhost data]# lsof -i:3306
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mysqld 23841 mysql 10u IPv6 756200 0t0 TCP *:mysql (LISTEN)

登录成功

退出mysql 直接ctrl + z

***************************************************************************************

有错误 看看错误日志里记录啥了

查看错误日志

vi /usr/etc/mysql/data/localhost.localdomain.err

150130 11:29:18 mysqld_safe Starting mysqld daemon with databases from /usr/etc/mysql/data
2015-01-30 11:29:19 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --

explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-30 11:29:19 22264 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

2015-01-30 11:29:19 22264 [ERROR] Aborting

2015-01-30 11:29:19 22264 [Note] Binlog end
2015-01-30 11:29:19 22264 [Note] /usr/etc/mysql/bin/mysqld: Shutdown complete

150130 11:29:19 mysqld_safe mysqld from pid file /usr/etc/mysql/data/localhost.localdomain.pid ended
150130 11:36:24 mysqld_safe Starting mysqld daemon with databases from /usr/etc/mysql/data

2015-01-30 11:36:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --

explicit_defaults_for_timestamp server option (see documentation for more details).
2015-01-30 11:36:25 22903 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
2015-01-30 11:36:25 22903 [ERROR] Aborting

2015-01-30 11:36:25 22903 [Note] Binlog end
2015-01-30 11:36:25 22903 [Note] /usr/etc/mysql/bin/mysqld: Shutdown complete

150130 11:36:25 mysqld_safe mysqld from pid file /usr/etc/mysql/data/localhost.localdomain.pid ended

*************************************************************************************

可能出现的问题：

我出现下面这个问题就是没有mysql这个用户 还没有给安装目录权限的问题

[root@localhost mysql]# service mysql start
Starting MySQL. ERROR! The server quit without updating PID file (/usr/etc/mysql/localhost.localdomain.pid).

具体如下解决的

[root@localhost data]# useradd mysql

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

参考
http://blog.rekfan.com/articles/186.html

*************************************************************************************

---

以下是参考记录而已~

查看user表里的记录 /usr/etc/mysql/bin

[root@localhost bin]# mysql -e "SELECT * FROM user" mysql

mysql -e "SELECT Host,User,Password FROM user" mysql

最后我还安装了

下载perl
wget http://www.cpan.org/src/5.0/perl-5.20.1.tar.gz

[root@localhost src]# wget http://www.cpan.org/src/5.0/perl-5.20.1.tar.gz
解压

tar zxvf perl-5.20.1.tar.gz -C /usr/local/bin

进入解压目录

[root@localhost src]# cd /usr/local/bin/perl-5.20.1

[root@localhost perl-5.20.1]./Configure -des -Dprefix=/usr/etc/perl

[root@localhost perl-5.20.1]make

[root@localhost perl-5.20.1]make install

查看是否安装好模块
[root@localhost mysql]# gcc -v
使用内建 specs。
COLLECT_GCC=gcc
COLLECT_LTO_WRAPPER=/usr/libexec/gcc/x86_64-redhat-linux/4.8.2/lto-wrapper
目标：x86_64-redhat-linux
配置为：../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-

bugurl=http://bugzilla.redhat.com/bugzilla --enable-bootstrap --enable-shared --enable-threads=posix --enable-

checking=release --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-gnu-unique-object --

enable-linker-build-id --with-linker-hash-style=gnu --enable-languages=c,c++,objc,obj-c++,java,fortran,ada,go,lto --

enable-plugin --enable-initfini-array --disable-libgcj --with-isl=/builddir/build/BUILD/gcc-4.8.2-20140120/obj-x86_64-

redhat-linux/isl-install --with-cloog=/builddir/build/BUILD/gcc-4.8.2-20140120/obj-x86_64-redhat-linux/cloog-install --

enable-gnu-indirect-function --with-tune=generic --with-arch_32=x86-64 --build=x86_64-redhat-linux
线程模型：posix
gcc 版本 4.8.2 20140120 (Red Hat 4.8.2-16) (GCC)

[root@localhost mysql]# perl -v

This is perl 5, version 16, subversion 3 (v5.16.3) built for x86_64-linux-thread-multi
(with 25 registered patches, see perl -V for more detail)

Copyright 1987-2012, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl". If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.

[root@localhost scripts]# yum install -y perl-Module-Install.noarch

*****************************************************************

给自己补充用的知识点

MySQL安全配置向导mysql_secure_installation

运行mysql_secure_installation会执行几个设置：
  a)为root用户设置密码
  b)删除匿名账号
  c)取消root用户远程登录
  d)删除test库和对test库的访问权限
  e)刷新授权表使修改生效

进入安装目录cd /usr/etc/mysql/bin

执行 mysql_secure_installation 回车 一般都是直接Y