数据库学习之--RedHat EL55下Mysql源码包安装

左手的ㄟ右手 2022-08-05 07:25 263阅读 0赞

**数据库学习之--RedHat EL55下Mysql源码包安装**

**系统环境****：**

**操作系统：RedHat EL55**

**DB Soft：  Mysql 5.6.4-m7**

**    Mysql 在linux下的安装方式有两种版本，一种为Binary（二进制），另外一种为Source（源码包），本文为Source Install方式。**

**1、安装前的准备**

解压安装包

\[oracle@ogg ~\]$ ls

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  mysql-5.6.4-m7  mysql-5.6.4-m7.tar.gz  mysql-5.6.4-m7.tar.zip  ogg  oradiag\_oracle  Readme--?+?.htm

\[oracle@ogg ~\]$ cd mysql-5.6.4-m7

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \[oracle@ogg mysql-5.6.4-m7\]$ ls  
2.  BUILD        CMakeLists.txt   COPYING              extra               libmysql     mysql-test  README   sql-bench   support-files  vio  
3.  BUILD-CMAKE  cmd-line-utils   dbug                 include             libmysqld    mysys       regex    sql-common  tests          win  
4.  client       config.h.cmake   Docs                 INSTALL-SOURCE      libservices  packaging   scripts  storage     unittest       zlib  
5.  cmake        configure.cmake  Doxyfile-perfschema  INSTALL-WIN-SOURCE  man          plugin      sql      strings     VERSION

**\[oracle@ogg mysql-5.6.4-m7\]$ tar zxvf mysql-5.6.4-m7.tar.gz**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  mysql-5.6.4-m7/mysql-test/lib/My/SafeProcess/  
2.  mysql-5.6.4-m7/mysql-test/lib/My/SafeProcess/safe\_process.cc  
3.  mysql-5.6.4-m7/mysql-test/lib/My/SafeProcess/safe\_kill\_win.cc  
4.  mysql-5.6.4-m7/mysql-test/lib/My/SafeProcess/safe\_process\_win.cc  
5.  mysql-5.6.4-m7/mysql-test/lib/My/SafeProcess/Base.pm  
6.  mysql-5.6.4-m7/mysql-test/lib/My/SafeProcess/CMakeLists.txt  
7.  ……

**查看官方安装文档：INSTALL-SOURCE**

** To install and use a MySQL binary distribution, the basic command**

**  sequence looks like this:**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  shell> groupadd mysql  
2.  shell> useradd -r -g mysql mysql  
3.  shell> cd /usr/local  
4.  shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz  
5.  shell> ln -s full-path-to-mysql-VERSION-OS mysql  
6.  shell> cd mysql  
7.  shell> chown -R mysql .  
8.  shell> chgrp -R mysql .  
9.  shell> scripts/mysql\_install\_db --user=mysql  
10. shell> chown -R root .  
11. shell> chown -R mysql data  
12. \# Next command is optional  
13. shell> cp support-files/my-medium.cnf /etc/my.cnf  
14. shell> bin/mysqld\_safe --user=mysql &  
15. \# Next command is optional  
16. shell> cp support-files/mysql.server /etc/init.d/mysql.server

** For example, with a compressed tar file source distribution on Unix, the basic installation command**

**sequence looks like this:**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \# Preconfiguration setup  
2.  shell> groupadd mysql  
3.  shell> useradd -r -g mysql mysql  
4.  \# Beginning of source-build specific instructions  
5.  shell> tar zxvf mysql-VERSION.tar.gz  
6.  shell> cd mysql-VERSION  
7.  shell> cmake .  
8.  shell> make  
9.  shell> make install  
10. \# End of source-build specific instructions  
11. \# Postinstallation setup  
12. shell> cd /usr/local/mysql  
13. shell> chown -R mysql .  
14. shell> chgrp -R mysql .  
15. shell> scripts/mysql\_install\_db --user=mysql  
16. shell> chown -R root .  
17. shell> chown -R mysql data  
18. \# Next command is optional  
19. shell> cp support-files/my-medium.cnf /etc/my.cnf  
20. shell> bin/mysqld\_safe --user=mysql &  
21. \# Next command is optional  
22. shell> cp support-files/mysql.server /etc/init.d/mysql.server

**2、准备源码安装所需要的工具和库文件（RedHat 安装光盘）**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \[root@ogg ~\]\# rpm -qa |grep make  
2.  automake-1.11.1-1.2.el6.noarch  
3.  make-3.81-19.el6.i686  
4.    
5.  \[root@ogg ~\]\# rpm -qa |grep bison  
6.  bison-2.4.1-5.el6.i686  
7.    
8.  \[root@ogg ~\]\# rpm -qa |grep gcc  
9.  gcc-c++-4.4.4-13.el6.i686  
10. libgcc-4.4.4-13.el6.i686  
11. gcc-4.4.4-13.el6.i686  
12. gcc-gfortran-4.4.4-13.el6.i686  
13. compat-libgcc-296-2.96-144.el6.i686  
14.   
15. \[root@ogg ~\]\# rpm -qa |grep cmake  
16.   
17. \[root@ogg ~\]\# rpm -qa |grep ncur  
18. ncurses-base-5.7-3.20090208.el6.i686  
19. ncurses-libs-5.7-3.20090208.el6.i686  
20. ncurses-5.7-3.20090208.el6.i686  
21. ncurses-devel-5.7-3.20090208.el6.i686  
22.   
23. 挂载RedHat安装光盘  
24. \[root@ogg ~\]\# mount /dev/cdrom /media/  
25. mount: block device /dev/sr0 is write-**protected**, mounting read-only  
26. \[root@ogg ~\]\# cd /media/  
27. \[root@ogg media\]\# cd Server/  
28. \[root@ogg Server\]\# ls  
29. Packages  repodata  TRANS.TBL  
30. \[root@ogg Server\]\# cd Packages/  
31.   
32. \[root@ogg Packages\]\# ls |grep make  
33. automake-1.11.1-1.2.el6.noarch.rpm  
34. imake-1.0.2-11.el6.i686.rpm  
35. make-3.81-19.el6.i686.rpm  
36. makebootfat-1.4-10.el6.i686.rpm  
37. pacemaker-1.1.2-7.el6.i686.rpm  
38. pacemaker-libs-1.1.2-7.el6.i686.rpm

**对于RedHat EL55系统，安装光盘不包含cmake文件，需要从网上下载安装**

**下载地址：http://www.cmake.org/download/**

\[root@rh55 soft\]\# ls  
cmake-3.2.3  cmake-3.2.3.tar.gz    
**\[root@rh55 soft\]\# tar zxvf cmake-3.2.3.tar.gz **

cmake-3.2.3/Utilities/cmliblzma/liblzma/delta/delta_decoder.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/delta/delta_encoder.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/delta/delta_encoder.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/delta/delta_private.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/liblzma.pc.in
    cmake-3.2.3/Utilities/cmliblzma/liblzma/liblzma_w32res.rc
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_decoder.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_decoder.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_encoder.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_encoder.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_encoder_hash.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_encoder_hash_table.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lz/lz_encoder_mf.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lzma/fastpos.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lzma/fastpos_table.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lzma/fastpos_tablegen.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lzma/lzma2_decoder.c
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lzma/lzma2_decoder.h
    cmake-3.2.3/Utilities/cmliblzma/liblzma/lzma/lzma2_encoder.c
    ......

**通过源码包编译安装cmake：**

**\[root@rh55 cmake-3.2.3\]\# ./configure --prefix=/usr/local/cmake**

CMake 3.2.3, Copyright 2000-2015 Kitware, Inc.
    Found GNU toolchain
    C compiler on this system is: gcc 
    C++ compiler on this system is: g++ 
    Makefile processor on this system is: gmake
    g++ is GNU compiler
    g++ has setenv
    g++ has unsetenv
    g++ does not have environ in stdlib.h
    g++ has STL in std:: namespace
    g++ has ANSI streams
    g++ has streams in std:: namespace
    g++ has sstream
    g++ has operator!=(string, char*)
    g++ has stl iterator_traits
    g++ has standard template allocator
    g++ has allocator<>::rebind<>
    g++ does not have non-standard allocator<>::max_size argument
    g++ has stl containers supporting allocator objects
    g++ has stl wstring
    g++ has header cstddef
    g++ requires template friends to use <>
    g++ supports member templates
    g++ has standard template specialization syntax
    g++ has argument dependent lookup
    .......

**\[root@rh55 cmake-3.2.3\]\# make**

Scanning dependencies of target cmIML_test
    [  0%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test.c.o
    [  0%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_ABI_C.c.o
    [  0%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_INT_C.c.o
    [  0%] Building C object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_include_C.c.o
    [  1%] Building CXX object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_ABI_CXX.cxx.o
    [  1%] Building CXX object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_INT_CXX.cxx.o
    [  1%] Building CXX object Utilities/KWIML/test/CMakeFiles/cmIML_test.dir/test_include_CXX.cxx.o
    Linking CXX executable cmIML_test
    [  1%] Built target cmIML_test
    Scanning dependencies of target cmsys
    [  1%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/ProcessUNIX.c.o
    [  1%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/Base64.c.o
    [  2%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/EncodingC.c.o
    [  2%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/MD5.c.o
    [  2%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/Terminal.c.o
    [  2%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/System.c.o
    [  2%] Building C object Source/kwsys/CMakeFiles/cmsys.dir/String.c.o
    [  2%] Building CXX object Source/kwsys/CMakeFiles/cmsys.dir/Directory.cxx.o
    [  3%] Building CXX object Source/kwsys/CMakeFiles/cmsys.dir/DynamicLoader.cxx.o
    [  3%] Building CXX object Source/kwsys/CMakeFiles/cmsys.dir/EncodingCXX.cxx.o
    [  3%] Building CXX object Source/kwsys/CMakeFiles/cmsys.dir/Glob.cxx.o
    ......
    [100%] Built target foo

**\[root@rh55 cmake-3.2.3\]\# make install**

[  1%] Built target cmIML_test
    [  4%] Built target cmsys
    [  4%] Built target cmsysTestDynload
    [  5%] Built target cmsys_c
    [  5%] Built target cmsysTestProcess
    [  5%] Built target cmsysTestSharedForward
    [  6%] Built target cmsysTestsC
    [  8%] Built target cmsysTestsCxx
    [ 10%] Built target cmzlib
    [ 28%] Built target cmcurl
    [ 28%] Built target LIBCURL
    [ 29%] Built target cmcompress
    [ 30%] Built target cmbzip2
    [ 41%] Built target cmliblzma
    [ 58%] Built target cmlibarchive
    [ 59%] Built target cmexpat
    [ 59%] Built target cmjsoncpp
    [ 66%] Built target cmForm
    [ 84%] Built target CMakeLib
    [ 87%] Built target CPackLib
    [ 95%] Built target CTestLib
    ......
    Installing: /usr/local/cmake/bin/cmake
    -- Installing: /usr/local/cmake/bin/ctest
    -- Installing: /usr/local/cmake/bin/cpack
    -- Installing: /usr/local/cmake/share/cmake-3.2/include/cmCPluginAPI.h
    -- Installing: /usr/local/cmake/share/cmake-3.2/editors/vim/cmake-help.vim
    -- Installing: /usr/local/cmake/share/cmake-3.2/editors/vim/cmake-indent.vim
    -- Installing: /usr/local/cmake/share/cmake-3.2/editors/vim/cmake-syntax.vim
    -- Installing: /usr/local/cmake/share/cmake-3.2/editors/emacs/cmake-mode.el
    -- Installing: /usr/local/cmake/share/aclocal/cmake.m4
    -- Installing: /usr/local/cmake/share/cmake-3.2/completions/cmake
    -- Installing: /usr/local/cmake/share/cmake-3.2/completions/cpack
    -- Installing: /usr/local/cmake/share/cmake-3.2/completions/ctest

**安装完成校验：**  
\[root@rh55 ~\]\# cd /usr/local/cmake  
\[root@rh55 cmake\]\# ls -l  
total 12  
drwxr-xr-x 2 root root 4096 Jun  9 17:47 bin  
drwxr-xr-x 3 root root 4096 Jun  9 17:47 doc  
drwxr-xr-x 4 root root 4096 Jun  9 17:47 share  
\[root@rh55 cmake\]\# cd bin  
\[root@rh55 bin\]\# ls -l  
total 41812  
\-rwxr-xr-x 1 root root 10054392 Jun  9 17:46 ccmake  
\-rwxr-xr-x 1 root root  9969999 Jun  9 17:46 cmake  
\-rwxr-xr-x 1 root root 10764389 Jun  9 17:46 cpack  
\-rwxr-xr-x 1 root root 11948376 Jun  9 17:46 ctest  
**建立可执行文件查找路径：**  
\[root@rh55 bin\]\# cat /etc/profile  
export PATH=$PATH:/usr/local/cmake/bin

**cmake安装成功后，安装mysql源码包：**

**3、源码安装，检测编译环境**

**\[root@rh55 mysql-5.6.4-m7\]\# cmake ./**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \-- The C compiler identification is GNU  
2.  \-- The CXX compiler identification is GNU  
3.  \-- Check **for** working C compiler: /usr/bin/gcc  
4.  \-- Check **for** working C compiler: /usr/bin/gcc -- works  
5.  \-- Detecting C compiler ABI info  
6.  \-- Detecting C compiler ABI info - done  
7.  \-- Check **for** working CXX compiler: /usr/bin/c++  
8.  \-- Check **for** working CXX compiler: /usr/bin/c++ -- works  
9.  \-- Detecting CXX compiler ABI info  
10. \-- Detecting CXX compiler ABI info - done  
11. \-- Looking **for** SHM\_HUGETLB  
12. \-- Looking **for** SHM\_HUGETLB - found  
13. \-- MySQL 5.6.4-m7  
14. \-- Looking **for** sys/types.h  
15. \-- Looking **for** sys/types.h - found  
16. \-- Looking **for** stdint.h  
17. \-- Looking **for** stdint.h - found

......

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \-- Performing Test HAVE\_IB\_GCC\_ATOMIC\_BUILTINS  
2.  \-- Performing Test HAVE\_IB\_GCC\_ATOMIC\_BUILTINS - Success  
3.  \-- Performing Test HAVE\_IB\_ATOMIC\_PTHREAD\_T\_GCC  
4.  \-- Performing Test HAVE\_IB\_ATOMIC\_PTHREAD\_T\_GCC - Success  
5.  \-- Check size of pthread\_t  
6.  \-- Check size of pthread\_t - done  
7.  \-- Performing Test HAVE\_PEERCRED  
8.  \-- Performing Test HAVE\_PEERCRED - Success  
9.  \-- Googletest was not found. gtest-based unit tests will be disabled. You can run cmake . -DENABLE\_DOWNLOADS=1 to automatically download and build required components from source.  
10. \-- If you are inside a firewall, you may need to use an http proxy: export http\_proxy=http://foo.bar.com:80  
11. \-- Configuring done  
12. \-- Generating done  
13. \-- Build files have been written to: /home/oracle/mysql-5.6.4-m7

**可以指定一下参数：**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \# -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql          \\    \#安装路径  
2.  \# -DMYSQL\_DATADIR=/usr/local/mysql/data            \\    \#数据文件存放位置  
3.  \# -DSYSCONFDIR=/etc                                \\    \#my.cnf路径  
4.  \# -DWITH\_MYISAM\_STORAGE\_ENGINE=1                   \\    \#支持MyIASM引擎  
5.  \# -DWITH\_INNOBASE\_STORAGE\_ENGINE=1                 \\    \#支持InnoDB引擎  
6.  \# -DWITH\_MEMORY\_STORAGE\_ENGINE=1                   \\    \#支持Memory引擎  
7.  \# -DWITH\_READLINE=1                                \\    \#快捷键功能(我没用过)  
8.  \# -DMYSQL\_UNIX\_ADDR=/tmp/mysqld.sock               \\    \#连接数据库socket路径  
9.  \# -DMYSQL\_TCP\_PORT=3306                            \\    \#端口  
10. \# -DENABLED\_LOCAL\_INFILE=1                         \\    \#允许从本地导入数据  
11. \# -DWITH\_PARTITION\_STORAGE\_ENGINE=1                \\    \#安装支持数据库分区  
12. \# -DEXTRA\_CHARSETS=all                             \\    \#安装所有的字符集  
13. \# -DDEFAULT\_CHARSET=utf8                           \\    \#默认字符  
14. \# -DDEFAULT\_COLLATION=utf8\_general\_ci

**4、编译**

**\[root@rh55 mysql-5.6.4-m7\]\# make**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  Scanning dependencies of target INFO\_BIN  
2.  \[  0%\] Built target INFO\_BIN  
3.  Scanning dependencies of target INFO\_SRC  
4.  \[  0%\] Built target INFO\_SRC  
5.  Scanning dependencies of target abi\_check  
6.  \[  0%\] Built target abi\_check  
7.  \[  1%\] Generating common.h  
8.  \[  1%\] Generating help.c  
9.  \[  1%\] Generating help.h  
10. \[  1%\] Generating vi.h  
11. \[  1%\] Generating emacs.h  
12. \[  1%\] Generating fcns.c  
13. \[  1%\] Generating fcns.h  
14. Scanning dependencies of target edit  
15. ......

**5、安装**

**\[root@rh55 mysql-5.6.4-m7\]\# make install**

**\[cpp\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_row\_sp003.test  
2.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_mts\_crash\_safe.inc  
3.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_stm\_EE\_err2.test  
4.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_ndb\_apply\_status.test  
5.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_mixing\_engines.test  
6.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_extra\_col\_slave.test  
7.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/type\_conversions.test  
8.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_row\_func003.test  
9.  \-- Installing: /usr/local/mysql/mysql-test/./extra/rpl\_tests/rpl\_row\_sp002.test  
10. ......

@至此，mysql安装完成！

**6、数据库配置**

**\[java\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  初始化数据库  
2.  \[root@ogg mysql\]\#cd /usr/local/mysql  
3.  \[root@ogg mysql\]\# ls  
4.  bin  COPYING  data  docs  include  INSTALL-BINARY  lib  man  mysql-5.6.4\-m7  mysql-test  README  scripts  share  sql-bench  support-files  
5.    
6.  \[root@ogg mysql\]\# chown -R mysql:mysql .  
7.    
8.  \[root@ogg mysql\]\# scripts/mysql\_install\_db --user=mysql  
9.  Installing MySQL system tables...  
10. 140917 13:51:22 InnoDB: The InnoDB memory heap is disabled  
11. 140917 13:51:22 InnoDB: Mutexes and rw\_locks use GCC atomic builtins  
12. 140917 13:51:22 InnoDB: Compressed tables use zlib 1.2.3  
13. 140917 13:51:22 InnoDB: Using Linux **native** AIO  
14. 140917 13:51:22 InnoDB: CPU does not support crc32 instructions  
15. 140917 13:51:22 InnoDB: Initializing buffer pool, size = 128.0M  
16. 140917 13:51:22 InnoDB: Completed initialization of buffer pool  
17. InnoDB: The first specified data file ./ibdata1 did not exist:  
18. InnoDB: a **new** database to be created!  
19. 140917 13:51:22 InnoDB: Setting file ./ibdata1 size to 10 MB  
20. InnoDB: Database physically writes the file full: wait...  
21.   
22. \[root@ogg mysql\]\# chown -R mysql:mysql ./data  
23. \[root@ogg mysql\]\# chmod -R ug+rws .  
24.   
25. \[root@ogg mysql\]\# cp support-files/my-medium.cnf /etc/my.cnf  
26. cp: overwrite \`/etc/my.cnf'? y  
27.   
28. 配置参数文件  
29. \[root@ogg mysql\]\# vi /etc/my.cnf  
30. \[mysqld\]  
31. port            = 3306  
32. socket          = /tmp/mysql.sock  
33. skip-external-locking  
34. key\_buffer\_size = 16M  
35. max\_allowed\_packet = 1M  
36. table\_open\_cache = 64  
37. sort\_buffer\_size = 512K  
38. net\_buffer\_length = 8K  
39. read\_buffer\_size = 256K  
40. read\_rnd\_buffer\_size = 512K  
41. myisam\_sort\_buffer\_size = 8M  
42. user=mysql  
43. datadir=/usr/local/mysql/data/mysql  
44. **default**\-storage-engine=MyISAM

**7、启动数据库**

**\[root@rh55 mysql\]\# bin/mysqld\_safe --user=mysql &**

\[1\] 16592

**\[java\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \[root@ogg mysql\]\# 140917 13:56:51 mysqld\_safe Logging to '/usr/local/mysql/data/mysql/ogg.err'.  
2.  140917 13:56:51 mysqld\_safe Starting mysqld daemon with databases from /usr/local/mysql/data/mysql  
3.  140917 13:56:53 mysqld\_safe mysqld from pid file /usr/local/mysql/data/mysql/ogg.pid ended  
4.  \[1\]+  Done                    bin/mysqld\_safe --user=mysql  
5.  \[root@ogg mysql\]\# ps -ef |grep mysql  
6.  root     16888  5955  0 13:57 pts/1    00:00:00 grep mysql

数据库启动失败！

查看日志：

**\[root@rh55 mysql\]\# cat /usr/local/mysql/data/mysql/ogg.err**

**\[java\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  140917 13:56:51 mysqld\_safe Starting mysqld daemon with databases from /usr/local/mysql/data/mysql  
2.  /usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist  
3.  140917 13:56:51 \[ERROR\] Can't open the mysql.plugin table. Please run mysql\_upgrade to create it.  
4.  140917 13:56:51 InnoDB: The InnoDB memory heap is disabled  
5.  140917 13:56:51 InnoDB: Mutexes and rw\_locks use GCC atomic builtins  
6.  140917 13:56:51 InnoDB: Compressed tables use zlib 1.2.3  
7.  140917 13:56:51 InnoDB: Using Linux **native** AIO  
8.  140917 13:56:51 InnoDB: CPU does not support crc32 instructions  
9.  140917 13:56:51 InnoDB: Initializing buffer pool, size = 128.0M  
10. 140917 13:56:52 InnoDB: Completed initialization of buffer pool  
11. InnoDB: The first specified data file ./ibdata1 did not exist:  
12. InnoDB: a **new** database to be created!  
13. 140917 13:56:52 InnoDB: Setting file ./ibdata1 size to 10 MB  
14. InnoDB: Database physically writes the file full: wait...  
15. 140917 13:56:52 InnoDB: Log file ./ib\_logfile0 did not exist: **new** to be created  
16. InnoDB: Setting log file ./ib\_logfile0 size to 5 MB  
17. InnoDB: Database physically writes the file full: wait...  
18. 140917 13:56:52 InnoDB: Log file ./ib\_logfile1 did not exist: **new** to be created  
19. InnoDB: Setting log file ./ib\_logfile1 size to 5 MB  
20. InnoDB: Database physically writes the file full: wait...  
21. InnoDB: Doublewrite buffer not found: creating **new**  
22. InnoDB: Doublewrite buffer created  
23. 140917 13:56:52 InnoDB: 128 rollback segment(s) are active.  
24. InnoDB: Creating foreign key constraint system tables  
25. InnoDB: Foreign key constraint system tables created  
26. 140917 13:56:52 InnoDB: Waiting **for** the background threads to start  
27. 140917 13:56:53 InnoDB: 1.2.4 started; log sequence number 0  
28. 140917 13:56:53 \[Warning\] No existing UUID has been found, so we assume that **this** is the first time that **this** server has been started. Generating a **new** UUID: 6c803c62-3e2f-11e4-9db1-0800270ccfcc.  
29. 140917 13:56:53 \[ERROR\] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist  
30. 140917 13:56:53 mysqld\_safe mysqld from pid file /usr/local/mysql/data/mysql/ogg.pid ended

重新启动数据库

\[root@rh55 mysql\]\# cd bin

**\[root@rh55 bin\]\# ./mysqld**

./mysqld: Table 'mysql.plugin' doesn't exist
    140917 13:58:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    140917 13:58:17 InnoDB: The InnoDB memory heap is disabled
    140917 13:58:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140917 13:58:17 InnoDB: Compressed tables use zlib 1.2.3
    140917 13:58:17 InnoDB: Using Linux native AIO
    140917 13:58:17 InnoDB: CPU does not support crc32 instructions
    140917 13:58:17 InnoDB: Initializing buffer pool, size = 128.0M
    140917 13:58:17 InnoDB: Completed initialization of buffer pool
    140917 13:58:17 InnoDB: highest supported file format is Barracuda.
    InnoDB: Log scan progressed past the checkpoint lsn 48961
    140917 13:58:17  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 1595695
    140917 13:58:17  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
    InnoDB: Apply batch completed
    140917 13:58:17 InnoDB: 128 rollback segment(s) are active.
    140917 13:58:17 InnoDB: Waiting for the background threads to start
    140917 13:58:18 InnoDB: 1.2.4 started; log sequence number 1595695
    140917 13:58:18 [Note] Recovering after a crash using mysql-bin
    140917 13:58:18 [Note] Starting crash recovery...
    140917 13:58:18 [Note] Crash recovery finished.
    140917 13:58:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

**数据库启动失败 **

140917 13:58:18 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

**解决方法：**

修改/etc/my.cnf

\[mysqld\]

datadir=/var/lib/mysql

重新指定数据库数据文件的位置！

再次启动Database：

\[root@rh55 mysql\]\# bin/mysqld\_safe --user=mysql &

**\[java\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \[root@ogg data\]\# ps -ef |grep mysql  
2.  root     16955  5955  0 14:03 pts/1    00:00:00 /bin/sh ./mysqld\_safe --user=mysql  
3.  mysql    17229 16955  0 14:03 pts/1    00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/var/lib/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/lib/mysql/ogg.err --pid-file=/var/lib/mysql/ogg.pid --socket=/tmp/mysql.sock --port=3306  
4.    
5.  \[root@ogg data\]\# netstat -an|grep 3306  
6.  tcp        0      0 0.0.0.0:3306                0.0.0.0:\*                   LISTEN

数据库启动成功！

配置数据库启动脚本，加入系统启动环境

**\[java\]**  [view plain][] [copy][view plain] [print][view plain] [?][view plain]

1.  \[root@ogg mysql\]\# cp support-files/mysql.server  /etc/init.d/mysql  
2.    
3.  \[root@ogg mysql\]\# service mysql stop  
4.  Shutting down MySQL..140917 14:06:29 mysqld\_safe mysqld from pid file /var/lib/mysql/ogg.pid ended  
5.                                                             \[  OK  \]  
6.  \[1\]+  Done                    ./mysqld\_safe --user=mysql  (wd: /usr/local/mysql/bin)  
7.  (wd now: /usr/local/mysql)  
8.  \[root@ogg data\]\# netstat -an|grep 3306  
9.    
10. \[root@ogg mysql\]\# service mysql start  
11. Starting MySQL..     
12. \[root@ogg data\]\# netstat -an|grep 3306  
13. tcp        0      0 0.0.0.0:3306                0.0.0.0:\*                   LISTEN                                        \[  OK  \]

8、连接使用mysql database

修改管理员密码
    [root@rh55 mysql]# cd /usr/local/mysql/
    [root@rh55 mysql]# ./bin/mysqladmin -u root password
    New password:
    Confirm new password:
    
    连接数据库
    [root@rh55 mysql]# ./bin/mysql -u root -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.6.4-m7-log Source distribution
    Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    mysql> select * from tab;
    ERROR 1046 (3D000): No database selected
    
    mysql> use mysql
    Database changed
    
    mysql> select * from tab;
    ERROR 1146 (42S02): Table 'mysql.tab' doesn't exist
    mysql> select host,user from mysql.user;
    +-----------+------+
    | host      | user |
    +-----------+------+
    | 127.0.0.1 | root |
    | ::1       | root |
    | localhost |      |
    | localhost | root |
    | ogg       |      |
    | ogg       | root |
    +-----------+------+
    6 rows in set (0.00 sec)
    mysql>

**@至此，mysql database安装、连接成功！**

[view plain]: http://blog.csdn.net/lqx0405/article/details/44777491#