CentOS 5.5 64bit下源碼編譯安裝MySQL 5.5.42

標籤：mysql

1.下載源碼包

MySQL 5.5.42

http://mysql.mirror.kangaroot.net/Downloads/MySQL-5.5/mysql-5.5.42.tar.gz

cmake 3.2.1

http://www.cmake.org/files/v3.2/cmake-3.2.1.tar.gz

2.檢查環境：

rpm -qa | grep cmake

rpm -qa | grep gcc 

rpm -qa | grep gcc-c++

3.安裝篇：

cmake-3.2.1

通過xftp上傳cmake-3.2.1.tar.gz至/usr/local/src

#tar zxvf cmake-3.2.1.tar.gz

#cd /usr/local/src/cmake-3.2.1

#./configure --prefix=/usr/local/cmake

#make && make install

#vim ~/.bash_profile

修改PATH=$PATH:$HOME/bin

    PAHT=$PATH:$HOME/bin:/usr/local/cmake/bin

儲存退出

#source ~/.bash_profile

mysql-5.5.42

#cd /usr/local/src/

#tar zxvf mysql-5.5.42.tar.gz

#cd mysql-5.5.42

#useradd -r -s /sbin/nologin mysql

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGING=1 -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=ALL -DMYSQL_USER=mysql

#gmake

#make install

#cd /usr/local/mysql

#cd support-files/

#ls mysql.server(查看是否有x許可權)

#cp mysql.server /etc/init.d/mysql

#cp my-large.cnf /etc/my.cnf

#vim /etc/my.cnf

添加如下行：

basedir = /usr/local/mysql

datadir = /data/mysql

socker = /tmp/mysqld.sock

port = 3306

儲存退出

#mkdir -p /data/mysql

#chown -R mysql. /data/mysql

#cd /usr/local/mysql/scripts/

#./mysql_install_db --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --no-defaults --user=mysql

#cd /data/mysql

#ls

#service mysql start

#ps -ef | grep mysql（查看是否存在mysql進程）

#vim ~/.bash_profile 

在PATH變數後面追加":/usr/local/mysql/bin"，修改完成後的結果如下：

PATH=$PATH:$HOME/bin:/usr/local/cmake/bin:/usr/local/mysql/bin（註：/usr/local/cmake/bin目錄為本實驗編譯安裝所產生的目錄，如果您的cmake是通過rpm或者是yum來安裝的，無此路徑。PATH=$PATH:$HOME/bin:/usr/local/mysql/bin）

#source ~/.bash_profile 

也可修改全域變數

#vim /etc/bashrc

在最後添加

PATH=$PATH:/usr/local/mysql/bin:/usr/local/cmake/bin(註：/usr/local/cmake/bin為本實驗編譯安裝所產生的目錄。)

#mysql

mysql>\s

本文出自 “LOT” 部落格，請務必保留此出處http://6294180.blog.51cto.com/6284180/1627922

CentOS 5.5 64bit下源碼編譯安裝MySQL 5.5.42