3、修改环境变量

#配置环境变量
vim .profile
#修改后
#mysql@Fight:~$ cat .profile
# ~/.profile: executed by the command interpreter for login shells.
# This file is not read by bash(1), if ~/.bash_profile or ~/.bash_login
# exists.
# see /usr/share/doc/bash/examples/startup-files for examples.
# the files are located in the bash-doc package.

# the default umask is set in /etc/profile; for setting the umask
# for ssh logins, install and configure the libpam-umask package.
#umask 022

# if running bash
if [ -n "$BASH_VERSION" ]; then
    # include .bashrc if it exists
    if [ -f "$HOME/.bashrc" ]; then
        . "$HOME/.bashrc"
    fi
fi

# set PATH so it includes user's private bin directories
PATH="$HOME/bin:$HOME/.local/bin:$PATH:/u01/svr/mysql5.7/bin"

4、编译

#1. cmake 
cmake \
-DCMAKE_INSTALL_PREFIX=/u01/svr/mysql5.7 \
-DINSTALL_DATADIR=/u01/svr/mysql5.7/data  \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_SSL=yes \
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/u01/svr/mysql5.7/run/mysql.sock \
-DENABLED_LOCAL_INFILE=1 \
-DSYSCONFDIR=/etc \
-DWITH_BOOST=boost \
-DWITH_READLINE=on

#2. make
#3. make install

5、初始化

#初始化
./mysqld --defaults-file=/u01/conf/mysql/my3306.cnf --initialize-insecure --datadir=/u01/mydata/my3306 --user=mysql
./mysqld --defaults-file=/u01/conf/mysql/my3307.cnf --initialize-insecure --datadir=/u01/mydata/my3307 --user=mysql

6、启动

#启动
./mysqld_safe --defaults-file=/u01/conf/mysql/my3306.cnf --user=mysql &
./mysqld_safe --defaults-file=/u01/conf/mysql/my3307.cnf --user=mysql &

7、进入

#mysql --socket=/tmp/mysql3306.sock --port=3306
./m6

#mysql --socket=/tmp/mysql3307.sock --port=3306
./m7

#远程连接
./m6
#进入mysql
set password for root@localhost = password('rootroot');
#还不行
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootroot' WITH GRANT OPTION;
FLUSH   PRIVILEGES;

8、配置数据库密码安全性

#3306
mysql_secure_installation -uroot -prootroot --socket=/tmp/mysql3306.sock
#3307
mysql_secure_installation -uroot -prootroot --socket=/tmp/mysql3307.sock
#取消密码验证

三、安装5.6

升级OpenSSL