#准备环境
yum install -y gcc-c++ ncurses-devel make cmake wget gzip.x86_64 perl autoconf
#创建MySQL用户和组
useradd mysql -s /sbin/nologin
#5.7开始要依赖boost的c++扩展
#安装包一般下载到/opt/下
cd /opt/
#下载要保证网络没问题,能访问的包的网页(这里是老刘的192.168.3.200)
(wget其他网页也行,重要的是包必须是mysql-5.6.48.tar.gz)
wget http://192.168.3.200/package/gz/mysql-5.6.48.tar.gz
echo "loading.................."
#解压
gunzip mysql-5.6.48.tar.gz
tar -xvf mysql-5.6.48.tar
cd /opt/mysql-5.6.48
#解决依赖关系
yum install -y openssl-devel.x86_64
yum install bison* -y
#创建datadir的路径
mkdir -p /data/mysqldata
chown mysql:mysql -R /data/mysqldata
#cmake编译
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysqldata -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost -DWITH_INNODB_MEMCACHED=ON
make
make install
#创建配置文件 /etc/my.cnf
echo -e "[mysqld]\nuser=mysql\ndatadir=/data/mysqldata\nserver_id=6\nlog-error=/var/log/mysql/error.log\npid-file=/data/mysqldata/mysql.pid\nport=3306\nsocket=/tmp/mysql.sock\n[mysql]\nsocket=/tmp/mysql.sock" >> /etc/my.cnf
chown mysql:mysql -R /usr/local/mysql
#初始化
chmod a+x /opt/mysql-5.6.48/scripts/mysql_install_db
/opt/mysql-5.6.48/./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --defaults-file=/etc/my.cnf
#复制support-files/mysql.sercer 到 /etc/init.d/并命名为mysqld5.6
cp /opt/mysql-5.6.48/support-files/mysql.server /etc/init.d/mysqld5.6
chmod a+x /etc/init.d/mysqld5.6
#启动服务
/etc/init.d/./mysqld5.6 start
#做一个软连接,LINUX默认命令放在/usr/bin下,不做找不到mysql命令
ln -s /usr/local/mysql/bin/mysql /usr/bin