本文共 2769 字,大约阅读时间需要 9 分钟。
1,Shell脚本mysql二进制安装
#!/bin/bash echo "+------------------------------------------------------------------------+" echo "| Centos Server, Install Mysql 5.6.25 |" echo "+------------------------------------------------------------------------+" echo "| A tool to auto-compile & install Mysql by binary on Centos |" echo "+------------------------------------------------------------------------+" echo "| For more information please visit http://blog.csdn.net/stubborn_cow |" echo "+------------------------------------------------------------------------+" # Check if mysql is exists rpm -qa | grep mysql-libs if [ $? -eq 0 ];then yum remove -y mysql-libs fi # add group and user groupadd mysql useradd -r -g mysql mysql # tar mysql.tar.gz tar zxvf /home/mysql-5.6.25-linux-glibc2.5-x86_64.tar.gz mv /root/mysql-5.6.25-linux-glibc2.5-x86_64 /usr/local/mysql # install mysql cd /usr/local/mysql scripts/mysql_install_db --user=mysql # update mysql configure file cd support-files cp my-default.cnf /etc/my.cnf cp mysql.server /etc/init.d/mysql # update mysql configure file cat > /etc/my.cnf <<EOF [mysqld] port=3306 datadir=/usr/local/mysql/data log-error=/usr/local/mysql/mysql_log.err character-set-server=utf8 collation-server=utf8_bin skip-name-resolve # slowlog slow_query_log=on slow_query_log_file=mysql-slow long_query_time = 1 # binlog #server-id = 1 log-bin=mysql-bin expire_logs_days = 30 # thread #thread_cache_size = 64 # innodb #innodb_buffer_pool_size = 2048M innodb_log_file_size = 500M innodb_log_files_in_group = 3 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES EOF chown -R mysql /usr/local/mysql # export profile file echo "export PATH=\$PATH:/usr/local/mysql/bin" >> /etc/profile source /etc/profile # iptables stop service iptables stop # chkconfig to mysql stop chkconfig mysql on chkconfig --add mysql #杀掉mysql进程,因为执行scripts/mysql_install_db时已经存在mysql进程,如果不杀掉mysql进程,service mysql start就会无法启动 #暂时没有找到更好的办法 px -aux|grep -v mysql|xargs kill -9 # strat mysql #service mysql restart # init mysql #mysql -uroot -e "delete from mysql.user where user ='';"; #mysql -uroot -e "update mysql.user set password = password('123456')"; #mysql -uroot -e "update mysql.user set password = password('123456')"; #mysql -uroot -e "drop database test"; #mysql -uroot -e "flush privileges"; echo "+------------------------------------------------------------------------+" echo "| Install Mysql Completed ! |" echo "+------------------------------------------------------------------------+" echo "| Wecome To Mysql |" echo "+------------------------------------------------------------------------+" echo "| For more information please visit http://blog.csdn.net/stubborn_cow |" echo "+------------------------------------------------------------------------+"