#!/bin/bash
#创建mysql用户
id mysql &> /dev/null
[ $? -eq 0 ] && echo -e "\033[35mmysql用户已存在\033[0m" && exit
useradd mysql
#将压缩包解压至mysql家目录下
tar -xf mysql*.tar.gz -C /home/mysql/
cd /home/mysql
mv mysql-* mysql
#修改配置文件
echo > /etc/my.cnf
sed -i "1a[mysql]\ndefault-character-set=utf8\n[mysqld]\nserver_id=1\n
log-bin=mysql-bin\nbasedir=/home/mysql/mysql\ndatadir=/home/mysql/mysql/data\n
skip-grant-tables\nport=23306\nsocket=/home/mysql/mysql/mysql.sock\n
explicit_defaults_for_timestamp\ncharacter-set-server=utf8\nlog_bin_trust_function_creators=1\n
lower_case_table_names=1\nsql_mode=\ntransaction_isolation=READ-COMMITTED\n
binlog_format=mixed\nmax_allowed_packet=104857600\nmax_connections=4000\n[mysqld_safe]\n
socket=/home/mysql/mysql/mysql.sock\n[client]\nsocket=/home/mysql/