編譯安裝mysql

標籤：mysql

#安裝cmake

#安裝依賴包

yum install gcc-c++ ncurses-devel –y

 

#安裝指令碼：

tar xf cmake-2.8.8.tar.gz

cd cmake-2.8.8

./configure

gmake

gmake install

cd ../

#建立mysql 使用者及組

groupadd mysql

useradd mysql -s /sbin/nologin -M -g mysql

#解壓編譯mysql

#指定字元集

#-DDEFAULT_CHARSET=utf8 \

#-DDEFAULT_COLLATION=utf8_general_ci \

 

tar zxf mysql-5.5.32.tar.gz

cd mysql-5.5.32

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

#-- Build files have been written to:/home/oldboy/tools/mysql-5.5.32

#提示，編譯時間可配置的選項很多，具體可參考結尾附錄或官方文檔：

make

#[100%] Built target my_safe_process

make install

ln -s /application/mysql-5.5.32/ /application/mysql

#選擇設定檔

/bin/cp support-files/my-small.cnf /etc/my.cnf

#多執行個體配置環境變數#方法一

echo ‘export PATH=/application/mysql/bin:$PATH‘>> /etc/profile

echo `tail -1 /etc/profile`

source /etc/profile

echo $PATH

#方法二

 #把/usr/local/mysql/bin 下面的命令拷貝到全域系統命令路徑/usr/local/sbin,或者做link串連

#路徑不對，在編譯安裝前有yum安裝mysql，解決方案

#http://oldboy.blog.51cto.com/2361410/1122867

#初始化資料庫

/bin/sh/application/mysql/scripts/mysql_install_db  --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql

#複製mysql啟動指令碼到init.d中，並授權

/bin/cp /root/tools/mysql-5.5.32/support-files/mysql.server/etc/init.d/mysqld

chmod +x /etc/init.d/mysqld 

echo "ll /etc/init.d/mysql"

echo `ll /etc/init.d/mysqld`

 

find /data/ -type f -name "mysql" |xargs chmod +x

#啟動資料庫

/etc/init.d/mysqld start

netstat -lntup |grep 3306

lsof -i :3306

#啟動資料庫

/etc/init.d/mysqld start

netstat -lntup |grep 3306

lsof -i :3306

本文出自 “it1693” 部落格，請務必保留此出處http://it1693.blog.51cto.com/2342744/1692982

編譯安裝mysql