centos7.3+mysq5.7.18 binary安装

mysq5.7.18 binary安装
1, mysql 下载及解压
   解压路径：
   tar zxvf mysql-advanced-5.7.18-linux-glibc2.5-x86_64.tar.gz
   移到目录/usr/local/，并更名为mysql：
   mv mysql-advanced-5.7.18-linux-glibc2.5-x86_64z /data/mysql
   
2，mysql 路径及用户的创建
  添加用户及组：
  groupadd mysql
  useradd -g mysql mysql
 
  生成路径
  mkdir -p /data/3306/data /data/3306/logs/log   /data/3307/data /data/3307/logs/log
 
  设置mysql目录的所有者及组：
  chown -R mysql:mysql /data

3，创建DB instance
   /data/3306/必须为空
   defaults-file 在5.7.14版本之后就不再使，如果使用就会报错
   
   ./mysqld --initialize-insecure --datadir=/data/3306/data --basedir=/data/mysql/ --user=mysql  --defaults-file=/data/3306/my.cnf

   这里说明下，初始化参数我使用了--initialize-insecure，这样不会设置初始化root密码，如果是 --initialize的话，会随机生成一个密码：
   在5.7.14版本之后就不再使，如果使用就会报错
   [root@centos128 bin]# mysqld --initialize-insecure --datadir=/data/3306/data --basedir=/data/mysql/ --user=mysql  --defaults-file=/data/3306/my.cnf
2017-06-22T13:38:42.569214Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-06-22T13:38:42.693496Z 0 [Warning] InnoDB: New log files created, LSN=45790
2017-06-22T13:38:42.733273Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2017-06-22T13:38:42.793859Z 0 [ERROR] unknown variable 'defaults-file=/data/3306/my.cnf'
2017-06-22T13:38:42.793908Z 0 [ERROR] Aborting

   [root@centos128 bin]# mysqld --initialize-insecure --datadir=/data/3306/data --basedir=/data/mysql/ --user=mysql  
2017-06-22T13:47:17.371866Z 0 [Warning] option 'table_open_cache_instances': unsigned value 128 adjusted to 64
2017-06-22T13:47:17.372814Z 0 [Warning] The syntax '--metadata_locks_hash_instances' is deprecated and will be removed in a future release
2017-06-22T13:47:17.372836Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2017-06-22T13:47:17.374983Z 0 [ERROR] You have enabled the binary log, but you haven't provided the mandatory server-id. Please refer to the proper server start-up parameters documentation
2017-06-22T13:47:17.375006Z 0 [ERROR] Aborting

[root@centos128 bin]# mysqld --initialize-insecure --datadir=/data/3306/data --basedir=/data/mysql/ --user=mysql  

启动数据库:
/data/mysql/bin/mysqld_safe --defaults-file=/data/3306/my.cnf  --user=mysql &
关闭数据库:

/data/mysql/bin/mysqladmin -u root -proot -S /data/3306/mysql.sock shutdown

关闭启动脚本:

port=`pwd | cut -c13-16`

mysql_user="root"

mysql_pwd="root"

CmdPath="/mysql/bin"

mysql_sock="/mysql/data/${port}/${port}.sock"

start(){

if [ ! -e "$mysql_sock" ];then

printf "Starting MySQL...\n"

/bin/sh ${CmdPath}/mysqld_safe --defaults-file=/mysql/data/${port}/my.cnf 2>&1 > /dev/null &

else

printf "MySQL is running...\n"

exit 1

fi

}

stop(){

if [ ! -e "$mysql_sock" ];then

printf "MySQL is stopped...\n"

exit 1

else

printf "Stoping MySQL...\n"

${CmdPath}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown

echo "${CmdPath}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S ${mysql_sock} shutdown"

fi

}

restart(){

printf "Restarting MySQL...\n"

stop

sleep 2

start

}

case "$1" in

start)

start

;;

stop)

stop

;;

restart)

restart

;;

*)

printf "Usage: /mysql/data/${port}/mysql {start|stop|restart}\n"

esac