1、先安裝依賴庫(yum安裝)
yum install -y cmake make gcc gcc- c++ bison ncurses ncurses-devel
2、下載Boost1.59.0源代碼，并解壓到/home/develop/目錄下，修改名稱為boost
tar –zxvf boost_1_59_0.tar.gz
mv boost_1_59_0 boost
3、添加mysql用戶，用戶組
添加mysql用戶組
group add mysql
添加mysql用戶
useradd -r -g mysql -s /bin/false mysql
4、下載mysql5.7源碼，并解壓到/home/develop下
tar –zxvf mysql-5.7.18_.tar.gz
5、新建mysql安裝目錄和mysql存放數(shù)據(jù)目錄
mkdir mkdir mysql
cd mysql
mkdir data
chown -R mysql:mysql /home/develop/mysql
6、預(yù)編譯在解壓MySQL目錄下執(zhí)行
cmake . -DCMAKE_INSTALL_PREFIX=/home/develop/mysql
-DMYSQL_DATADIR=/home/develop/mysql/data
-DWITH_BOOST=/home/develop/boost
-DSYSCONFDIR=/etc
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_unicode_ci
-DENABLED_LOCAL_INFILE=1
-DEXTRA_CHARSETS=all
7、編譯并安裝(紅色部分用``括起來)
make -j
grep processor /proc/cpuinfo | wc -l&& make install
8、新建mysql配置文件/etc/my.cnf，內(nèi)容如下
[mysql]
# 設(shè)置mysql客戶端默認(rèn)字符集
default-character-set=utf8
socket=/home/develop/mysql/mysql.sock
[mysqld]
user=mysql
port=3306
basedir=/home/develop/mysql
datadir=/home/develop/mysql/data
tmpdir=/home/develop/mysql/temp
socket=/home/develop/mysql/mysql.sock
explicit_defaults_for_timestamp=true
open_files_limit=10240
back_log=600
max_connections=500
max_connect_errors=6000
wait_timeout=605800
max_allowed_packet=32M
sort_buffer_size=4M
join_buffer_size=4M
thread_cache_size=300
query_cache_type=1
query_cache_size=256M
query_cache_limit=2M
query_cache_min_res_unit=16k
tmp_table_size=256M
max_heap_table_size=256M
key_buffer_size=256M
read_buffer_size=1M
read_rnd_buffer_size=16M
bulk_insert_buffer_size=64M
lower_case_table_names=1
default-storage-engine=INNODB
innodb_buffer_pool_size=2G
innodb_log_buffer_size=32M
innodb_log_file_size=128M
innodb_flush_method=O_DIRECT
long_query_time=2
[mysqldump]
quick
max_allowed_packet=32M
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8
collation-server=utf_unicode_ci
skip-external-locking
skip-name-resolve
[mysqld_safe]
9、初始化系統(tǒng)數(shù)據(jù)庫并加密
cd mysql
mkdir temp
chown –R mysql:mysql /home/develop/mysql
./bin/mysqld --initialize-insecure --user=mysql --basedir=/home/develop/mysql --datadir=/home/develop/mysql/data
./bin/mysql_ssl_rsa_setup
10、配置mysql環(huán)境變量
在/etc/profile后面追加 export PATH=/home/develop/mysql/bin:$PATH
立即生效
source /etc/profile
11、配置mysql服務(wù)，開機(jī)自啟
cd /home/develop/mysql
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --list mysqld
chkconfig mysqld on
12、啟動(dòng)mysql服務(wù)
啟動(dòng)mysql
systemctl start mysql
停止mysql
systemctl stop mysql
重啟mysql
systemctl restart mysql
查看mysql狀態(tài)
systemctl status mysql
13、設(shè)置防火墻
開啟mysql 3306端口號(hào)
firewall-cmd --zone=public --add-port=3306/tcp --permanent
重啟防火墻
firewall-cmd --reload
14、設(shè)置數(shù)據(jù)庫密碼
連接mysql，給當(dāng)前root用戶設(shè)置密碼（mysql –u root –p123456）
set password=password('123456');
新建mysql用戶并授權(quán)開啟遠(yuǎn)程登錄(將host設(shè)為%即可)
grant all privileges on . to mysql@'%' identified by '123456' with grant option;
生效
flush privileges;
