Mysql-5.5.32 cmake安装

原文：http://blog.csdn.net/u011364306/article/details/47604617

1.拷贝cmake-2.8.8.tar.gz和mysql-5.5.32.tar.gz至/opt文件夹下 
2.切换到opt目录

[root@mysql ~]# cd /opt[root@mysql opt]# lscmake-2.8.8.tar.gz  mysql-5.5.32.tar.gz  rh
1
2
3

3.解压cmake文件

[root@mysql opt]# tar xf cmake-2.8.8.tar.gz[root@mysql opt]# cd cmake-2.8.8[root@mysql cmake-2.8.8]# lsbootstrap                   CompileFlags.cmake    doxygen.configChangeLog.manual            configure             ExampleChangeLog.txt               Copyright.txt         ModulesCMakeCPack.cmake            CTestConfig.cmake     Readme.txtCMakeCPackOptions.cmake.in  CTestCustom.cmake.in  SourceCMakeGraphVizOptions.cmake  CTestCustom.ctest.in  TemplatesCMakeLists.txt              DartConfig.cmake      TestsCMakeLogo.gif               DartLocal.conf.in     Utilitiescmake_uninstall.cmake.in    Docs
1
2
3
4
5
6
7
8
9
10
11
12

4.进行cmake的安装

[root@mysql cmake-2.8.8]# ./configureCMake has bootstrapped.  Now run gmake.[root@mysql cmake-2.8.8]# gmake[root@mysql cmake-2.8.8]# gmake install
1
2
3
4
5

5.添加mysql用户和组

[root@mysql cmake-2.8.8]# groupadd mysql[root@mysql cmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql
1
2

6.yum安装ncurses-devel

[root@mysql /]# yum install ncurses-devel -y
1

7.解压mysql文件

[root@mysql /]# cd /opt[root@mysql opt]# tar xf mysql-5.5.32.tar.gz[root@mysql opt]# cd mysql-5.5.32[root@mysql mysql-5.5.32]# lsBUILD        CMakeLists.txt   COPYING  include             libmysqld    mysys      regex      sql-common     tests     winBUILD-CMAKE  cmd-line-utils   dbug     INSTALL-SOURCE      libservices  packaging  scripts    storage        unittest  zlibclient       config.h.cmake   Docs     INSTALL-WIN-SOURCE  man          plugin     sql        strings        VERSIONcmake        configure.cmake  extra    libmysql            mysql-test   README     sql-bench  support-files  vio
1
2
3
4
5
6
7
8

8.安装之前编译mysql

cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \-DMYSQL_DATADIR=/application/mysql-5.5.32/data \-DMYSQL_UNIX_ADDR=/application/mysql-5.5.32/tmp/mysql.sock \-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \-DENABLED_LOCAL_INFILE=ON \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_FEDERATED_STORAGE_ENGINE=1 \-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \-DWITH_FAST_MUTEXES=1 \-DWITH_ZLIB=bundled \-DENABLED_LOCAL_INFILE=1 \-DWITH_READLINE=1 \-DWITH_EMBEDDED_SERVER=1 \-DWITH_DEBUG=0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

9.mysql安装

[root@mysql mysql-5.5.32]# make && make install[root@mysql mysql-5.5.32]# ln -s /application/mysql-5.5.32/ /application/mysql
1
2
3

如果make到63%左右出现错误：

make[2]: * [storage/perfschema/unittest/pfs_connect_attr-t] Error 1

make[1]: * [storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/all] Error 2

则：cmake去掉-DWITH_PARTITION_STORAGE_ENGINE=1参数重新编译

10.选择配置文件

[root@mysql mysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnfcp: overwrite `/etc/my.cnf'? y
1
2

11.查看是否有mysql/data目录

[root@mysql mysql-5.5.32]# ll /application/mysql/data/total 4drwxr-xr-x. 2 root root 4096 Aug 15 15:38 test
1
2
3

12.相关授权

[root@mysql mysql-5.5.32]# chown -R mysql.mysql /application/mysql/data/[root@mysql mysql-5.5.32]# chmod -R 1777 /tmp/
1
2

13.数据库初始化

[root@mysql mysql-5.5.32]# cd /application/mysql/scripts/[root@mysql scripts]# lsmysql_install_db[root@mysql scripts]# cd /application/mysql/scripts/[root@mysql scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysqlInstalling MySQL system tables...OKFilling help tables...OK
1
2
3
4
5
6
7
8
9

14.启动配置

[root@mysql mysql]# cd /opt/mysql-5.5.32[root@mysql mysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld[root@mysql mysql-5.5.32]# chmod +x /etc/init.d/mysqld[root@mysql mysql-5.5.32]# /etc/init.d/mysqld startStarting MySQL.. SUCCESS![root@mysql mysql-5.5.32]# netstat -lntup|grep 3306tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      28462/mysqld 
1
2
3
4
5
6
7

15.配置环境变量

[root@mysql mysql-5.5.32]# echo 'export PATH=/application/mysql/bin:$PATH'>>/etc/profile[root@mysql mysql-5.5.32]# tail -1 /etc/profileexport PATH=/application/mysql/bin:$PATH[root@mysql mysql-5.5.32]# source /etc/profile[root@mysql mysql-5.5.32]# echo $PATH/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
1
2
3
4
5
6

16.登陆mysql，删除无用配置

[root@mysql mysql-5.5.32]# mysqlmysql> delete from mysql.user where user='';mysql> delete from mysql.user where host='mysql';mysql> delete from mysql.user where host='::1';mysql> select user,host from mysql.user;+------+-----------+| user | host      |+------+-----------+| root | 127.0.0.1 || root | localhost |+------+-----------+mysql> drop database test;
1
2
3
4
5
6
7
8
9
10
11
12

17.配置登陆密码

[root@mysql mysql-5.5.32]# /application/mysql//bin/mysqladmin -u root password 'cancer'
1

18.设置mysql开机启动

[root@mysql mysql-5.5.32]# chkconfig mysqld on[root@mysql mysql-5.5.32]# chkconfig --list mysqldmysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off
1
2
3

19.查看系统语言

[root@mysql mysql-5.5.32]# cat /etc/sysconfig/i18nLANG="en_US.UTF-8"SYSFONT="latarcyrheb-sun16"