[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

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

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

mkdir -p /home/nulige/mysql/3306/datamkdir -p /home/nulige/mysql/3306/tmpmkdir -p /home/nulige/mysql/3306/log

groupadd mysqluseradd -s /sbin/nologin -g mysql -M mysqlid mysql

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.gzwget https://osdn.net/frs/g_redir.php?m=netix&f=%2Flonenmp%2Flnmpfiles%2Fmysql%2Fmysql-5.7.11.tar.gz

   MySQL在5.5.3之后增加了这个utf8mb4的编码，mb4就是most bytes 4的意思，专门用来兼容四字节的unicode。好在utf8mb4是utf8的超集，除了将编码改为utf8mb4外不需要做其他转换。当然，为了节省空间，一般情况下使用utf8也就够了。

　　至于什么时候用，看你的做什么项目了。

在做移动应用时，会遇到ios用户会在文本的区域输入emoji表情，如果不做一定处理，就会导致插入数据库异常。

tar xzf boost_1_59_0.tar.gztar xzf mysql-5.7.11.tar.gzcd mysql-5.7.11cmake -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

#配置启动服务/bin/cp /home/nulige/mysql/3306/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqldchkconfig --add mysqldchkconfig mysqld on#/etc/my.cnf，仅供参考（用于生产还需要调优）[mysqld]basedir = /home/nulige/mysql/3306datadir = /home/nulige/mysql/3306/datatmpdir = /home/nulige/mysql/3306/tmppid-file = /home/nulige/mysql/3306/data/my.pidport = 3306default_storage_engine = InnoDBinnodb_autoinc_lock_mode = 2explicit_defaults_for_timestamp = truecharacter-set-client-handshake = FALSEcharacter_set_server = utf8skip-name-resolvemax_connect_errors = 1000000max_allowed_packet = 1Gconnect_timeout = 3600wait_timeout = 3600interactive_timeout = 3600innodb_lock_wait_timeout = 10slave-skip-errors  = 1032,1062log-error = /home/nulige/mysql/3306/log/error.logslow_query_log = onslow_query_log_file = /home/nulige/mysql/3306/log/slow-query-log.loglong_query_time = 1log-queries-not-using-indexeslog-slow-admin-statementslog-slow-slave-statementsserver-id = 100log-bin = log-binbinlog-format = ROW

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备注：这里会报一个警告，直接忽略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"会生成一个随机密码(~/.mysql_secret)，而"--initialize-insecure"不会生成密码，--datadir目标目录下不能有数据文件。

service mysqld start

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

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

echo ‘PATH=/home/nulige/mysql/3306/bin/:$PATH‘ >>/etc/profilesource /etc/profileecho $PATH

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

mysql -uroot -p‘:AyjdUl!3-;*‘   #这边密码要加引号，要么然的话存在转义问题

mysql> SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘1qaz@WSX‘);mysql> flush privileges; mysql> exitBye

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

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

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