|
RPM
安裝
|
二進(jìn)制安裝
|
源碼安裝
|
優(yōu)點(diǎn)
|
安裝簡單,適合初學(xué)者
|
安裝簡單,可以安裝到任何路徑下
|
可以根據(jù)使用需要定制編譯,靈活,性能最好
|
缺點(diǎn)
|
需要單獨(dú)下載服務(wù)端和客戶端,安裝路徑不夠靈活,默認(rèn)路徑不能修改
|
已經(jīng)經(jīng)過編譯,性能不如源碼安裝的好,無法靈活定制編譯參數(shù)
|
安裝過程復(fù)雜,編譯時間長
|
文件布局
|
/usr/bin
(客戶端程序和腳本)
/usr/sbin
(
mysqld
服務(wù)器)
/var/lib/mysql
(日志文件和數(shù)據(jù)庫)
/usr/include/mysql
(頭文件)
/usr/lib/mysql
(庫文件)
/usr/share/mysql
(錯誤消息和字符集文件)
|
bin
(
mysqld
服務(wù)器和客戶端程序)
data
(日志文件和數(shù)據(jù)庫)
include
(頭文件)
lib
(庫文件)
scripts
(
mysql_install_db
腳本)
share/mysql
(錯誤消息)
|
|
1
|
rpm -ivh MySQL-devel-5.6.31-1.el6.x86_64.rpm
|
1
2
|
groupadd mysql
useradd -g mysql mysql
|
1
|
./mysql_install_db --user=mysql
|
1
2
3
4
|
1.cmake
2.ncurses-devel
yum install cmake ncurses-devel -y
|
1
2
|
groupadd mysql
useradd mysql -s /sbin/nologin -M -g mysql
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6.28 \
-DMYSQL_DATADIR=/usr/local/mysql-5.6.28/data \
-DMYSQL_UNIX_ADDR=/usr/local/mysql-5.6.28/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=uft8_general_ci \
-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 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
make && make install
|
1
|
ln -s /usr/local/mysql-5.6.28 /usr/local/mysql
|
1
2
|
echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
source /etc/profile
|
1
|
chown -R mysql.mysql /usr/local/mysql-5.6.28
|
1
2
|
/usr/local/mysql/scripts
./mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
|
1
2
3
|
cd /usr/local/mysql/support-files
cp mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
|
1
2
|
service mysqld start #
啟動
mysql
service mysqld stop #
關(guān)閉
mysql
|
1
2
3
|
/etc/init.d/mysqld start #
啟動
mysql
/etc/init.d/mysqld stop #
關(guān)閉
mysql
/etc/init.d/mysqld restart #
重啟
mysql
|
1
|
$bindir/mysql_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null 2>&1 &
|
1
|
mysqladmin -uroot -ppassword shutdown #
只有具有
mysql
的
root
用戶才能執(zhí)行關(guān)閉操作。
|
1
2
3
|
killall mysqld
pkill mysqld
killall -9 mysqld
|