一、軟件包
a) cmake-2.8.3.tar.gz
b) mysql-5.5.8.tar.gz
二、安裝步驟
a) Tar zxvf cmake-2.8.3.tar.gz
b) Cd cmake-2.8.3
c) ./bootstrap
d) Make
e) Make install
f) Tar zxvf mysql-5.5.8.tar.gz
g) Cd mysql-5.5.8
h) 配置參數
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql5 \
-DINSTALL_DATADIR=/usr/local/mysql5/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_SSL=system \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1
i) Make
j) Make install
k) Useradd mysql �d /dev/null �s /sbin/nologin
l) Chown �R mysql:mysql /usr/local/mysql5/
m) Chown �r mysql:mysql /usr/local/mysql5/data
n) Cp ./support-files/my-medium.cnf /etc/my.cnf
o) Chown 744 ./scripts/mysql_install_db
p) ./scripts/mysql_install_db �user=mysql �basedir=/usr/local/mysql5 �datadir=/usr/local/mysql5/data
q) Chown �R mysql:mysql /usr/local/mysql5/data
r) /usr/local/mysql5/bin/mysqld_safe �user=mysql&
s) /usr/local/mysql5/bin/mysql �uroot
t) Mysql>use mysql;
u) Mysql>update user set password=password(‘123456’) where user=’root’;
v) Cp ./support-files/mysql.server /etc/init.d/mysql5
w) Chkconfig �add mysql5
x) Chkconfig mysql5 on
y) Service mysql5 restart
三、附件
a) 編譯選項說明
編譯選項說明：
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5 //安裝目錄
-DINSTALL_DATADIR=/usr/local/mysql5/data //數據庫存放目錄
-DDEFAULT_CHARSET=utf8 //使用utf8字符
-DDEFAULT_COLLATION=utf8_general_ci //校驗字符
-DEXTRA_CHARSETS=all //安裝所有擴展字符集
-DWITH_SSL=system //使用SSL加密 (bundled)
-DWITH_EMBEDDED_SERVER=1 //編譯成embedded mysql library
-DENABLED_LOCAL_INFILE=1 //允許從本地導入數據
-DWITH_MYISAM_STORAGE_ENGINE=1 //安裝myisam引擎
b) Mysql>show engines;
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
6 rows in set (0.01 sec)
