linux下cmake方式編譯安裝MySQL資料庫

標籤：command   linux   release   資料庫   

前言：MySQL資料庫自5.5版本以後，就開始使用CMake編譯工具進行安裝。

 

   安裝環境：

[[email protected] ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[[email protected] ~]# mysqladmin --version
mysqladmin  Ver 8.42 Distrib 5.6.14, for Linux on x86_64

1.安裝cmake源碼包（已安裝則略過此步）

#如果系統中無cmake命令，則需要下載cmake安裝包並進行安裝

[[email protected]]# cmake --version

-bash: cmake:command not found

[[email protected]]#Wget

http://wwwNaNake.org/files/v2.8/cmake-2.8.10.2.tar.gz--no-check-certificate  //下載cmake源碼包

[[email protected]]# tar -zxvf cmake-2.8.10.2.tar.gz                             //解壓安裝包

[[email protected]]# cd cmake-2.8.10.2                                           //進入解壓目錄

[[email protected]]# ./bootstrap                                        //執行

[[email protected]]# gmake                                              //編譯

[[email protected]]# gmake install                                      //安裝

[[email protected] ~]#cmake --version                                                 //驗證安裝

cmake version2.8.10.2

 

2.下載mysql安裝介質

#可到mysql網站進行下載相關版本並上傳至伺服器

http://www.mysql.com/

http://download.csdn.net/detail/sunny_sailor/8072429

 

3.建立mysql使用者及組

#建立安裝mysql所需要的使用者及組

[[email protected] ~]#groupaddmysql

[[email protected] ~]#useradd-r -g mysql mysql

 

4.安裝必要軟體包

#可配置本地或者互連網yum進行安裝

[[email protected] ~]# yum-y install  gcc gcc-c++ gcc-g77 autoconfautomake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl

 

5.編譯安裝mysql

#此步驟為cmake方式編譯安裝mysql

[[email protected] ~]#tar-xf mysql-5.6.14.tar.gz                                          #解壓

[[email protected] ~]#cdmysql-5.6.14                                                      #進入解壓目錄

[[email protected]]# cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-DMYSQL_DATADIR=/application/mysql/data -DSYSCONFDIR=/etc/mysql-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-DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci   #配置

[[email protected]]# make                                                     #編譯            

[[email protected]]# make install                                             #安裝

 

 

6.授權mysql安裝目錄許可權

#對mysql安裝目錄進行授權操作

[[email protected] ~]chmod-R mysql.mysql /application/mysql

 

 

7.初始化mysql資料庫

[[email protected]~]cd /application/mysql/scripts/

[[email protected]~]./mysql_install_db--user=mysql --basedir=/application/mysql --datadir=/application/mysql/data

 

 

8.配置mysql啟動服務

[[email protected]~]cd /application/mysql/support-files/

[[email protected]]# cp mysql.server /etc/rc.d/init.d/mysql

[[email protected]]# /bin/cp my-default.cnf /etc/my.cnf

[[email protected]~]chkconfig --add mysql

[[email protected]~]chkconfig mysql on

 

 

9.啟動mysql資料庫

[[email protected]~]/etc/init.d/mysql start

[[email protected]~]lsof -i:3306

 

10.修改字元集，防止亂碼

#添加如下配置內容，服務端字元集需要和用戶端保持一致

[[email protected]~]vim /etc/my.cnf

[mysqld]

character-set-server=utf8

[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[[email protected]~]/etc/init.d/mysql restart

 

11.將mysql bin加入到環境變數中

#加入如下配置代碼，也可加入全域環境變數中

[[email protected]~]# cd ~

[[email protected]~]vim .bash_profile    

[[email protected]~]# cat .bash_profile

#.bash_profile

 

#Get the aliases and functions

if[ -f ~/.bashrc ]; then

        . ~/.bashrc

fi

 

#User specific environment and startup programs

PATH=$PATH:$HOME/bin

PATH=/application/mysql/bin:$PATH

exportPATH

[[email protected]~]. .bash_profile

 

12.設定mysql資料庫密碼及遠端存取許可權

#mysql資料庫初次安裝完畢後，預設不要求輸入密碼可進行登入

[[email protected]~]# mysql –uroot

mysql>SETPASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘123456‘);                      #設定登入密碼

mysql>flush privileges;

QueryOK, 0 rows affected (0.00 sec)

[[email protected]~]# mysql –uroot                                                          #驗證

ERROR1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)

[[email protected]~]# mysql -uroot -p

Enterpassword:

 

 

 

 

 

 

 

 

 

 

 

 

本文出自 “笑傲&風雲” 部落格，請務必保留此出處http://6197435.blog.51cto.com/6187435/1866867

linux下cmake方式編譯安裝MySQL資料庫