1候生、編譯安裝MySQL需要一些必備的組件,可以直接使用yum安裝即可
yum -y install cmake ncurses-devel gcc-c++
2 創(chuàng)建 Mysql用戶
useradd mysql
3 分別給mysql創(chuàng)建程序安裝目錄和數(shù)據(jù)存儲(chǔ)目錄,這里將mysql安裝在/opt下,數(shù)據(jù)存儲(chǔ)在 /data/mysql下
mkdir /opt/mysql-5.6.39
chown -R mysql.mysql?/opt/mysql-5.6.39 (授權(quán))
mkdir /data/mysql/{log,data} -p
chown -R mysql.mysql?/data/mysql?(授權(quán))
mkdir /var/lib/mysql?
chown -R mysql.mysql?/var/lib/mysql?(授權(quán))
3 下載/解壓 Mysql
wget?http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.39.tar.gz
tar -xvf mysql-5.6.39.tar.gz
編譯:
(1)cmake \
-DCMAKE_INSTALL_PREFIX=/opt/mysql-5.6.39 \
-DMYSQL_DATADIR=/data/mysql \
-DSYSCONFDIR=/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
(2)make (大約20分鐘)
(3)make install?
4 初始化數(shù)據(jù)庫
cd /opt/mysql-5.6.39
scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
5 添加service
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
service mysql start ?—啟動(dòng)MySQL
修改vim /etc/profile文件弓候,在文件末尾添加
PATH=/usr/local/mysql/bin:$PATH
export PATH
source?/etc/profile