#! /bin/bash
config(){
echo "**************初始化数据"
mysql_bin="/usr/local/mysql/bin"
mysql_sock="/opt/apps/tmp/mysql/mysql.sock"
param="-h127.0.0.1 -uroot -proot"
#将root的密码设置为root
$mysql_bin/mysqladmin -S $mysql_sock -u root password ''root'' 2>/dev/null
#设置编码为UTF8
$mysql_bin/mysql -S $mysql_sock $param -e"SET character_set_client = utf8" 2>/dev/null
$mysql_bin/mysql -S $mysql_sock $param -e"SET character_set_connection = utf8" 2>/dev/null
$mysql_bin/mysql -S $mysql_sock $param -e"SET character_set_database = utf8" 2>/dev/null
$mysql_bin/mysql -S $mysql_sock $param -e"SET character_set_results = utf8" 2>/dev/null
$mysql_bin/mysql -S $mysql_sock $param -e"SET character_set_server = utf8" 2>/dev/null
#设置时区
$mysql_bin/mysql -S $mysql_sock $param -e"set global time_zone=\"+8:00\"" 2>/dev/null
$mysql_bin/mysql -S $mysql_sock $param -e"FLUSH PRIVILEGES" 2>/dev/null
}
install(){
echo "**************安装mysql"
#判断存在mysql进程,存在则关闭
if [[ 2 -gt `ps -ef|grep mysql|wc -l` ]];then
   echo " "
else
    echo "**************关闭mysql"
    `ps -ef|grep mysql|grep -v ''grep''|awk ''{print $2}''|xargs kill -9` 2>/dev/null
fi
#卸载系统自带mysql  
rpm -e --nodeps  `rpm -qa|grep mysql`
#配置文件所在目录
my_cnf="/etc/my.cnf"
#将解压后的mysql复制到/usr/local,也可以选择移动
cp -r mysql /usr/local/
echo "[mysqld]" >$my_cnf
echo "server-id = 1" >>$my_cnf
echo "port = 3306" >>$my_cnf
echo "mysqlx_port  = 33060" >>$my_cnf
echo "mysqlx_socket  = /opt/apps/tmp/mysql/mysqlx.sock" >>$my_cnf
echo "datadir  = /opt/apps/data/mysqldata" >>$my_cnf
echo "socket = /opt/apps/tmp/mysql/mysql.sock" >>$my_cnf
echo "pid-file = /opt/apps/tmp/mysql/mysqld.pid" >>$my_cnf
echo "log-error = error.log" >>$my_cnf
echo "slow-query-log = 1" >>$my_cnf
echo "slow-query-log-file  = slow.log" >>$my_cnf
echo "long_query_time = 0.2" >>$my_cnf
echo "log-bin  = bin.log" >>$my_cnf
echo "relay-log = relay.log" >>$my_cnf
echo "binlog_format =ROW" >>$my_cnf
echo "relay_log_recovery  = 1" >>$my_cnf
echo "character-set-client-handshake = FALSE" >>$my_cnf
echo "character-set-server = utf8mb4" >>$my_cnf
echo "collation-server  = utf8mb4_unicode_ci" >>$my_cnf
echo "init_connect =''SET NAMES utf8mb4''" >>$my_cnf
echo "innodb_buffer_pool_size = 1G" >>$my_cnf
echo "join_buffer_size  = 128M" >>$my_cnf
echo "sort_buffer_size  = 2M" >>$my_cnf
echo "read_rnd_buffer_size = 2M" >>$my_cnf
echo "log_timestamps = SYSTEM" >>$my_cnf
echo "lower_case_table_names  = 1" >>$my_cnf
echo "default-authentication-plugin = mysql_native_password" >>$my_cnf
echo "default-time-zone = ''+8:00''" >>$my_cnf
usergroup="mysql : mysql"
groupadd -f mysql
isusergroup=`groups mysql`
#判断是否存在mysql用户
if [ "$usergroup" = "$isusergroup" ];then
        echo "**************mysql用户已经在mysql组"
    else
        echo "**************添加mysql用户到mysql组"
        useradd mysql -g mysql
fi 
rm -rf /opt/apps/tmp/mysql
rm -rf /opt/apps/data/mysqldata
#配置mysql临时目录,防治在/tmp目录下被清理
mkdir -p /opt/apps/tmp/mysql
#配置数据目录，也可以改
mkdir -p /opt/apps/data/mysqldata
chown -R mysql:mysql /opt/apps/data/mysqldata
chown -R mysql:mysql /opt/apps/tmp/mysql
chmod -R 775 /opt/apps/data/mysqldata
chmod -R 775 /usr/local/mysql
/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/opt/apps/data/mysqldata --initialize-insecure
cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysql
/etc/init.d/mysql start
config
}
if [[ ! -d "/opt/apps/mysql" ]];then
echo "**************解压mysql"
tar -zxf mysql-8.0.17-el7-x86_64.tar.gz
mv mysql-8.0.17-el7-x86_64.tar.gz  mysql
fi
if [[ ! -d "/usr/local/mysql" ]];then
install
    else
echo "**************检查到mysql已经安装,跳过"
fi

[root@oldboy ~]# cat /etc/redhat-release 
CentOS release 6.5 (Final)
[root@oldboy ~]# uname -a
Linux oldboy 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

[root@oldboy ~]# mount /dev/cdrom /mnt
mount: block device /dev/sr0 is write-protected, mounting read-only
[root@oldboy ~]# yum -y install gcc-c++

---------------------------------------------
Error when bootstrapping CMake:
Cannot find appropriate C++ compiler on this system.
Please specify one using environment variable CXX.
See cmake_bootstrap.log for compilers attempted.
---------------------------------------------
Log of errors: /usr/local/cmake-3.0.2/Bootstrap.cmk/cmake_bootstrap.log

[root@oldboy ~]# mkdir -p /home/oldboy/tools
[root@oldboy ~]# cd /home/oldboy/tools
[root@oldboy tools]# chmod +x *

[root@oldboy tools]# yum -y install ncurses-devel-5.7-4.20090207.el6.x86_64.rpm 
…………………
Complete!

[root@oldboy tools]# tar zxf cmake-2.8.8.tar.gz
[root@oldboy tools]# cd cmake-2.8.8
[root@oldboy cmake-2.8.8]# ./configure
…………………
CMake has bootstrapped.  Now run gmake.
[root@oldboy cmake-2.8.8]# gmake
……………………
[100%] Built target foo
[root@oldboy cmake-2.8.8]# gmake install
……………………
-- Installing: /usr/local/doc/cmake-2.8/cpack.docbook
-- Installing: /usr/local/share/aclocal/cmake.m4

[root@oldboy tools]# groupadd mysql
[root@oldboy tools]# useradd -M mysql -g mysql -s /sbin/nologin
[root@oldboy tools]# tar zxf mysql-5.5.54.tar.gz 
[root@oldboy tools]# cd mysql-5.5.54
[root@oldboy mysql-5.5.54]# cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.54 \
-DMYSQL_DATADIR=/application/mysql-5.5.54/data \
-DMYSQL_UNIX_ADDR=/application/mysql-5.5.54/tmp/mysql.sock \
-DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \
-DENABLED_LOCAL_INFILE=ON \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
-DWITHOUT_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FAST_MUTEXES=1 \
-DWITH_ZLIB=bundled \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_READLINE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_DEBUG=0
……………………
-- Configuring done
-- Generating done
-- Build files have been written to: /home/oldboy/tools/mysql-5.5.54
[root@oldboy mysql-5.5.54]# make && make install
……………………
-- Installing: /application/mysql-5.5.54/man/man1/my_print_defaults.1
-- Installing: /application/mysql-5.5.54/man/man8/mysqld.8
[root@oldboy mysql-5.5.54]# ll /application/mysql/data/
总用量 4
drwxr-xr-x. 2 root root 4096 6月 22 00:18 test

[root@oldboy mysql-5.5.54]# ln -s /application/mysql-5.5.54/ /application/mysql
[root@oldboy mysql-5.5.54]# cp support-files/my-small.cnf /etc/my.cnf
cp: overwrite `/etc/my.cnf''? y
[root@oldboy mysql-5.5.54]# echo ''export PATH=/application/mysql/bin:$PATH''>>/etc/profile
[root@oldboy mysql-5.5.54]# source /etc/profile
[root@oldboy mysql-5.5.54]# echo $PATH
/application/mysql/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

[root@oldboy mysql-5.5.54]# chown -R mysql.mysql /application/mysql/data/
[root@oldboy mysql-5.5.54]# chmod -R 1777 /tmp/
[root@oldboy mysql-5.5.54]# cd /application/mysql/scripts/
[root@oldboy scripts]# ./mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data/ --user=mysql
……………………
Installing MySQL system tables...
181126 20:20:08 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
181126 20:20:08 [Note] /application/mysql//bin/mysqld (mysqld 5.5.54) starting as process 48267 ...
OK
Filling help tables...
181126 20:20:08 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
181126 20:20:08 [Note] /application/mysql//bin/mysqld (mysqld 5.5.54) starting as process 48274 ...
OK
……………………
Please report any problems at http://bugs.mysql.com/

[root@oldboy scripts]# cd /home/oldboy/tools/mysql-5.5.54
[root@oldboy mysql-5.5.54]# cp support-files/mysql.server /etc/init.d/mysqld
[root@oldboy mysql-5.5.54]# chmod +x /etc/init.d/mysqld 
[root@oldboy mysql-5.5.54]# mkdir -p /application/mysql-5.5.54/tmp
[root@oldboy mysql-5.5.54]# chown -R mysql.mysql /application/mysql-5.5.54/tmp

[root@oldboy mysql-5.5.54]# /etc/init.d/mysqld start
Starting MySQL.Logging to ''/application/mysql-5.5.54/data/oldboy.err''.
.[  OK  ]

[root@oldboy mysql-5.5.54]# /application/mysql//bin/mysqladmin -u root password ''oldboy''
[root@oldboy mysql-5.5.54]# mysql -uroot -poldboy
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.54 Source distribution

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ''help;'' or ''\h'' for help. Type ''\c'' to clear the current input statement.

mysql>