本文為大家分享了Linux環(huán)境下MySQL5.6.24自動安裝腳本代碼,供大家參考,具體內(nèi)容如下
創(chuàng)新互聯(lián)公司提供高防主機(jī)、云服務(wù)器、香港服務(wù)器、成都棕樹電信機(jī)房等
說明:
一、本腳本僅供測試使用,若正式環(huán)境想要使用,需更改腳本的一些參數(shù)。
二、使用本腳本之前,需保證linux環(huán)境可以聯(lián)網(wǎng)下載,若不能聯(lián)網(wǎng),則需要將下載好的mysql二進(jìn)制包上傳至linux中的/data目錄下。
三、腳本使用是需一次輸入三個(gè)參數(shù):
1、需安裝的mysql版本號,如:5.6.24
2、需安裝的mysql端口設(shè)置,如:3306
3、mysql的server_id設(shè)置,如:1003306
使用步驟:
1、將下列腳本上傳至linux環(huán)境中,我個(gè)人是以mysql_install.sh命名
#!/bin/bash #mysql_install by chen #Email:chenhz1218@gmail.com & 296966488@qq.com #version 2.0 #安裝版本 5.6.20-5.6.25 #安裝要求: #需要可以聯(lián)網(wǎng),若無網(wǎng)絡(luò),可以先創(chuàng)建/data目錄,將安裝包上傳到/data目錄下 #判斷/data目錄是否存在,若不存在則創(chuàng)建,并且下載mysql datamenu="/data" read -p "Input a mysql version:" -t 30 mysql_version read -p "Input a mysql port:" -t 30 mysql_port read -p "Input a mysql_server_id:" -t 30 mysql_server_id mysqlfile="$datamenu/mysql-$mysql_version-linux-glibc2.5-x86_64.tar.gz" if [ ! -d "$datamenu" ];then mkdir "$datamenu" wget -P /data http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-$mysql_version-linux-glibc2.5-x86_64.tar.gz elif [ ! -f "$mysqlfile" ];then wget -P /data http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-$mysql_version-linux-glibc2.5-x86_64.tar.gz fi #解壓下載好的mysql cd /opt mkdir mysql cd mysql tar zxvf $mysqlfile -C /opt/mysql #創(chuàng)建mysql用戶 egrep "^mysql" /etc/group >& /dev/null if [ $? -ne 0 ] then groupadd mysql fi #create user if not exists egrep "^mysql" /etc/passwd >& /dev/null if [ $? -ne 0 ] then useradd -g mysql -s /sbin/nologin -d /usr/local/mysql mysql fi #創(chuàng)建mysql軟連接,并授權(quán)給mysql用戶 cd /usr/local/ rm -rf /usr/local/mysql ln -s /opt/mysql/mysql-$mysql_version-linux-glibc2.5-x86_64 /usr/local/mysql chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /usr/local/mysql/ #基于配置文件,創(chuàng)建mysql安裝目錄,并授權(quán) mkdir -p /data/mysql mkdir -p /data/mysql/mysql${mysql_port} cd /data/mysql/mysql${mysql_port}/ mkdir /data/mysql/mysql${mysql_port}/data mkdir /data/mysql/mysql${mysql_port}/logs mkdir /data/mysql/mysql${mysql_port}/tmp chown -R mysql:mysql /data/mysql/mysql${mysql_port} cat > /etc/my.cnf << EOF [client] port = ${mysql_port} socket = /tmp/mysql.sock # The MySQL server [mysqld] # Basic port = ${mysql_port} user = mysql basedir = /usr/local/mysql datadir = /data/mysql/mysql${mysql_port}/data tmpdir = /data/mysql/mysql${mysql_port}/tmp socket = /tmp/mysql.sock log-bin = /data/mysql/mysql${mysql_port}/logs/mysql-bin log-error = error.log slow-query-log-file = slow.log skip-external-locking skip-name-resolve log-slave-updates lower_case_table_names = 1 #忽略表名大小寫 character_set_server = gbk innodb_file_per_table = 1 innodb_autoinc_lock_mode = 2 explicit_defaults_for_timestamp = true sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES EOF #初始化mysql cd /usr/local/mysql ./scripts/mysql_install_db --defaults-file=/etc/my.cnf #在/etc/init.d下創(chuàng)建mysql 啟動腳本 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql #添加環(huán)境變量,并使/etc/profile環(huán)境變量生效 echo "export PATH=$PATH:/usr/local/mysql/bin">>/etc/profile
export PATH=$PATH:/usr/local/mysql/bin
2、給腳本賦予可執(zhí)行權(quán)限,
[root@zabbix-server ~]# rz -y z waiting to receive.**B0100000023be50 [root@zabbix-server ~]# ls anaconda-ks.cfg install.log install.log.syslog mysql_install.sh [root@zabbix-server ~]# chmod +x mysql_install.sh [root@zabbix-server ~]# ls -al|grep mysql_install.sh -rwxr-xr-x. 1 root root 3136 Jul 29 10:29 mysql_install.sh
3、執(zhí)行腳本,并輸入三個(gè)參數(shù),等待數(shù)據(jù)庫安裝
[root@MySQL ~]# ./mysql_install.sh Input a mysql version:5.6.24 Input a mysql port:3306 Input a mysql_server_id:1003306
4、啟動數(shù)據(jù)庫
[root@MySQL ~]# /etc/init.d/mysql start Starting MySQL.. [ OK ] [root@zabbix-server ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.6.24-log MySQL Community Server (GPL) Copyright (c) 2000, 2015, 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> show databases -> ; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec) mysql>
至此,linux下mysql安裝已經(jīng)完成,可以使用它做一些測試了。
以上就是本文的全部內(nèi)容,希望對大家的學(xué)習(xí)有所幫助,也希望大家多多支持創(chuàng)新互聯(lián)。
本文名稱:Linux下mysql5.6.24(二進(jìn)制)自動安裝腳本
鏈接URL:http://bm7419.com/article18/pcshdp.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供域名注冊、做網(wǎng)站、網(wǎng)站設(shè)計(jì)公司、網(wǎng)站建設(shè)、全網(wǎng)營銷推廣、網(wǎng)站內(nèi)鏈
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)