MySQL安装脚本

MySQL安装脚本

**注：**本次安装版本为mysql-5.6.25-linux-glibc2.5-x86_64.tar.gz，shell脚本和mysql安装包tar.gz放在了 /opt/db 下，如需改变，请修改脚本第5，7，8，9行
直接上脚本代码：

#!/bin/sh
service sshd restart
service mysqld stop
userdel -f mysql
filepath=/opt/db
cd $filepath
rm /opt/db/mysql -rf
tar xf mysql-5.6.25-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.6.25-linux-glibc2.5-x86_64 mysql
cd $filepath/mysql
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /opt/db/mysql
rm /etc/my.cnf -rf
rm /etc/rc.d/init.d/mysqld -rf
cp ./support-files/my-default.cnf /etc/my.cnf 
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
rm /opt/db/mysql/data -rf
rm /opt/db/data -rf
mkdir -p /opt/db/data
mkdir -p /home/json
scripts/mysql_install_db --user=mysql --datadir=/opt/db/data
chown -R mysql data
sed -i 's:/usr/local/mysql:/opt/db/mysql:g' /etc/init.d/mysqld
sed -i 's:# datadir = .....:datadir = /opt/db/data:g' /etc/my.cnf
sed -i 's:/opt/db/mysql/data:/opt/db/data:g' /etc/init.d/mysqld
service mysqld start
sed -i '5a [client]\nsocket = /tmp/mysql.sock\ndefault-character-set = utf8' /etc/my.cnf
echo "socket = /tmp/mysql.sock" >> /etc/my.cnf
echo "lower_case_table_names = 1" >> /etc/my.cnf
echo "character-set-server=utf8" >> /etc/my.cnf
echo "init_connect = 'SET NAMES utf8'" >> /etc/my.cnf
echo "basedir =/opt/db/mysql" >> /etc/my.cnf
service mysqld restart
/opt/db/mysql/bin/mysqladmin -u root password
rm /etc/init.d/mysql -rf
cp /opt/db/mysql/support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
chkconfig --add mysql
chkconfig --level 345 mysql on

将以上脚本代码 粘贴到一个文本文档中（.txt）中保存并重命名文件为startupmysql.sh,
上传脚本到目标服务器的 /opt/db 目录下，修改startupmysql.sh的权限，
chmod 777 startupmysql.sh
执行脚本即可完成mysql的安装
./startupmysql.sh
优化MySQL远程连接

修改配置文件
vim /etc/my.cnf
添加参数
skip-name-resolve
重启MySQL
cd /opt/db/mysql/support-files
./mysql.server restart