mysql5.7.x 編譯安裝

一、卸載mariadb

[root@mysql5 ~]# rpm -qa mariadb*
//mariadb-libs-5.5.44-2.el7.centos.x86_64
[root@template tools]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
[root@template tools]# rpm -qa | grep mariadb

系統(tǒng)環(huán)境：

[root@mysql5 ~]# cat /etc/redhat-release 
//CentOS Linux release 7.2.1511 (Core) 
[root@mysql5 ~]# uname -r
//3.10.0-327.el7.x86_64

二净宵、編譯安裝mysql

安裝依賴包

yum install libaio-devel ncurses-devel cmake gcc gcc-c++ bison -y

文件目錄創(chuàng)建

mkdir -p /home/nulige/mysql/3306/data
mkdir -p /home/nulige/mysql/3306/tmp
mkdir -p /home/nulige/mysql/3306/log

創(chuàng)建用戶組和mysql用戶

groupadd mysql
useradd -s /sbin/nologin -g mysql -M mysql
id mysql

創(chuàng)建軟件目錄

mkdir -p /home/nulige/mysql 
cd /home/nulige/mysql

下載軟件

wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
wget https://osdn.net/frs/g_redir.php?m=netix&f=%2Flonenmp%2Flnmpfiles%2Fmysql%2Fmysql-5.7.11.tar.gz

utf8mb4格式解釋

MySQL在5.5.3之后增加了這個(gè)utf8mb4的編碼赚哗，mb4就是most bytes 4的意思嗦锐，專門用來兼容四字節(jié)的unicode顶猜。好在utf8mb4是utf8的超集晌姚，
除了將編碼改為utf8mb4外不需要做其他轉(zhuǎn)換粤剧。當(dāng)然，為了節(jié)省空間挥唠，一般情況下使用utf8也就夠了抵恋。
　　至于什么時(shí)候用，看你的做什么項(xiàng)目了宝磨。

在做移動(dòng)應(yīng)用時(shí)弧关，會(huì)遇到ios用戶會(huì)在文本的區(qū)域輸入emoji表情，如果不做一定處理唤锉，就會(huì)導(dǎo)致插入數(shù)據(jù)庫異常世囊。

解壓安裝

//解壓縮wget下來的壓縮包
tar xzf boost_1_59_0.tar.gz
tar xzf mysql-5.7.11.tar.gz

//進(jìn)入解壓好的目錄
cd mysql-5.7.11

cmake -DCMAKE_INSTALL_PREFIX=/home/nulige/mysql/3306 \
-DMYSQL_DATADIR=/home/nulige/mysql/3306/data \
-DWITH_BOOST=/home/nulige/mysql/boost_1_59_0 \
-DSYSCONFDIR=/home/nulige/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1

編譯安裝

make && make install

配置啟動(dòng)服務(wù)

/bin/cp /home/nulige/mysql/3306/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on

//編輯/etc/my.conf文件
#/etc/my.cnf，僅供參考（用于生產(chǎn)還需要調(diào)優(yōu)）
[mysqld]
basedir = /home/nulige/mysql/3306
datadir = /home/nulige/mysql/3306/data
tmpdir = /home/nulige/mysql/3306/tmp
pid-file = /home/nulige/mysql/3306/data/my.pid
port = 3306

default_storage_engine = InnoDB
innodb_autoinc_lock_mode = 2

explicit_defaults_for_timestamp = true
character-set-client-handshake = FALSE
character_set_server = utf8
skip-name-resolve
max_connect_errors = 1000000
max_allowed_packet = 1G

connect_timeout = 3600
wait_timeout = 3600
interactive_timeout = 3600
innodb_lock_wait_timeout = 10
slave-skip-errors  = 1032,1062
log-error = /home/nulige/mysql/3306/log/error.log

slow_query_log = on
slow_query_log_file = /home/nulige/mysql/3306/log/slow-query-log.log
long_query_time = 1
log-queries-not-using-indexes
log-slow-admin-statements
log-slow-slave-statements

server-id = 100
log-bin = log-bin
binlog-format = ROW

初始化數(shù)據(jù)庫

chown -R mysql:mysql /home/nulige/mysql/3306/

cd /home/nulige/mysql/3306/bin
 ./mysql_install_db --user=mysql --basedir=/home/nulige/mysql/3306 --datadir=/home/nulige/mysql/3306/data

備注：這里會(huì)報(bào)一個(gè)警告窿祥，直接忽略

2017-05-19 16:33:16 [WARNING] mysql_install_db is deprecated. Please consider switching to mysqld --initialize

意思：
之前版本mysql_install_db是在mysql_basedir/script下茸习，5.7放在了mysql_install_db/bin目錄下,且已被廢棄
"--initialize"會(huì)生成一個(gè)隨機(jī)密碼(~/.mysql_secret)，而"--initialize-insecure"不會(huì)生成密碼壁肋，--datadir目標(biāo)目錄下不能有數(shù)據(jù)文件号胚。
復(fù)制代碼

啟動(dòng) 數(shù)據(jù)庫

service mysqld start

設(shè)置開機(jī)自啟動(dòng)

[root@mysql5 ~]# systemctl enable mysqld.service
mysqld.service is not a native service, redirecting to /sbin/chkconfig.
Executing /sbin/chkconfig mysqld on

查看端口

[root@mysql5 bin]# ss -lntup|grep 3306
tcp    LISTEN     0      80       :::3306     :::*     users:(("mysqld",pid=25042,fd=23))

配置環(huán)境變量

echo 'PATH=/home/nulige/mysql/3306/bin/:$PATH' >>/etc/profile
source /etc/profile
echo $PATH

查看mysql默認(rèn)密碼

[root@mysql5 bin]# cat /root/.mysql_secret 
# Password set for user 'root@localhost' at 2017-05-19 16:33:16 
:AyjdUl!3-;*

用默認(rèn)密碼，登錄數(shù)據(jù)庫

mysql -uroot -p':AyjdUl!3-;*'   #這邊密碼要加引號(hào)浸遗，要么然的話存在轉(zhuǎn)義問題

修改密碼（這個(gè)密碼一定要足夠復(fù)雜猫胁，不然會(huì)不讓你改，提示密碼不合法）

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('1qaz@WSX');
mysql> flush privileges; 
mysql> exit
Bye

登錄數(shù)據(jù)庫

[root@mysql5 bin]# mysql -uroot -p'1qaz@WSX'

查看mysql版本

[root@mysql5 bin]# mysql -V
mysql  Ver 14.14 Distrib 5.7.11, for Linux (x86_64) using  EditLine wrapper

查看數(shù)據(jù)庫用戶表

mysql> select host,user from mysql.user;
+-----------+-----------+
| host      | user      |
+-----------+-----------+
| localhost | mysql.sys |
| localhost | root      |
+-----------+-----------+
2 rows in set (0.00 sec)

MYSQL-5.7源碼安裝