MYSQL
1. 查看mysql：rpm -qa mysql
2. yum安裝mysql：yum install mysql mysql-server mysql-devel -y
3. yum卸載mysql：yum remove mysql*
cmake? .? -DCMAKE_INSTALL_PREFIX=/usr/local/mysql55/ \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock?\
-DMYSQL_DATADIR=/data/mysql?\
-DSYSCONFDIR=/etc?\
-DMYSQL_USER=mysql?\
-DMYSQL_TCP_PORT=3306?\
-DWITH_XTRADB_STORAGE_ENGINE=1?\
-DWITH_INNOBASE_STORAGE_ENGINE=1?\
-DWITH_PARTITION_STORAGE_ENGINE=1?\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1?\
-DWITH_MYISAM_STORAGE_ENGINE=1?\
-DWITH_READLINE=1?\
-DENABLED_LOCAL_INFILE=1?\
-DWITH_EXTRA_CHARSETS=1?\
-DDEFAULT_CHARSET=utf8?\
-DDEFAULT_COLLATION=utf8_general_ci?\
-DEXTRA_CHARSETS=all?\
-DWITH_BIG_TABLES=1?\
-DWITH_DEBUG=0
對于MySQL的介紹文章并不多，當然你有興趣，可以看看mysql主從同步和mysql讀寫分離
http://blog.csdn.net/wanglei_storage/article/details/48808777
http://blog.csdn.net/wanglei_storage/article/details/48791361
安裝簡介
用戶名：mysql
安裝目錄：/usr/local/mysql
數(shù)據(jù)庫目錄：/usr/local/mysql/data
安裝前步驟
一、添加用戶
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
二、yum安裝依賴包
yum -y install gcc* ncurses-devel cmake bison
三、解包
tar zxf mysql-5.6.13.tar.gz -C /usr/src
cd /usr/src/mysql-5.6.13
四、創(chuàng)建數(shù)據(jù)目錄
mkdir -p /usr/local/mysql/data
五、cmake配置
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DWITH_SSL=yes -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGING=1 -DWITH_INNOBASE_STORAGE_ENGING=1 -DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306
六、編譯及安裝
make && make install
==============================創(chuàng)建啟動方式-并初始化===================
七、拷貝配置文件
cp support-files/my-default.cnf /usr/local/mysql/my.cnf
八、初始化數(shù)據(jù)庫
cd /usr/local/mysql/scripts/
./mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/ --basedir=/usr/local/mysql/
九、設置鏈接【此處可無】
ln -s /usr/local/mysql/bin/* /usr/local/bin/
ln -s /usr/local/mysql/include/mysql/* /usr/include/
ln -s /usr/local/mysql/lib/* /usr/lib/
十、設置權限
chown -R mysql:mysql /usr/local/mysql/
十一、修改my.cnf配置【/usr/local/mysql/my.cnf】
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/mysql_error.log
pid-file = /usr/local/mysql/mysql.pid
user = mysql
tmpdir = /tmp
十二、復制啟動進程
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
rm -rf /etc/my.cnf
ln -s /usr/local/mysql/my.cnf /etc
十三、啟動
/etc/init.d/mysqld start
例：如果sock文件丟失指定文件1，也可以鏈接2
進入mysql：/usr/local/mysql/bin/mysql
(1) mysql -S /var/lib/mysql/mysql.sock -u root
(2) ln -s /var/lib/mysql/mysql.sock /usr/local/mysql/mysql.sock
