MySQL (5-7) 安装脚本(python )

最新推荐文章于 2024-05-31 08:47:40 发布
Concentrer
最新推荐文章于 2024-05-31 08:47:40 发布
阅读量405
点赞数 1
CC 4.0 BY-SA版权
分类专栏： python
本文链接：https://blog.youkuaiyun.com/qq_43377292/article/details/92674569
python 专栏收录该内容
41 篇文章
订阅专栏
该博客主要围绕Python编写MySQL 5 - 7版本的安装脚本展开，虽内容仅提示大神勿喷，但核心是借助Python实现MySQL特定版本的安装。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
#!/usr/bin/python
#coding=utf-8
#Larryd.Yin

import commands
import os  
import shutil
import time
import sys
A = "A"
B = "B" 
C = "C"
a = "a"
b = "b" 
c = "c"
Y = "Y"
y = "y" 
N = "N"
R = "R"
r = "r"
m_name = "mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz"
m2_name = "ql-5.6.44-linux-glibc2.12-x86_64.tar.gz" 
m3_name = "mysql-5.7.26-linux-glibc2.12-x86_64.tar"
m_p = "/usr/local/mysql"
m_fp = "/etc/my.cnf"
def jnsystem():
	os.chdir("/usr/local/mysql")
	os.mkdir ("log")
	commands.getstatusoutput("chown -R mysql:mysql /usr/local/mysql")
        shutil.copy("support-files/mysql.server","/etc/init.d/mysql")
        msc = '/etc/init.d/mysql'
        mf = open("/etc/init.d/mysql","r")
        content = mf.read()
        mf.close()
        t = content.replace("basedir=", "basedir=/usr/local/mysql")
        with open (msc,"w") as f1:
                f1.write(t)
        mf2 = open("/etc/init.d/mysql","r")
        content = mf2.read()
        mf2.close()
        t1 = content.replace("datadir=", "datadir=/usr/local/mysql/data")
        with open (msc,"w") as f2:
                f2.write(t1)
        os.chdir ("/usr/local/mysql")
        commands.getstatusoutput("rm -rf my.cnf")
        f = 'my.cnf'
        with open(f,"w") as h_file:
        	h_file.write('[mysqld]'
                '\nbasedir=/usr/local/mysql'
                '\ndatadir=/usr/local/mysql/data'
                '\nsocket= /tmp/mysql.sock'
		'\nlog-error=/usr/local/mysql/log/error.log'
		'\nlog=/usr/local/mysql/log/mysql.log'
		'\nlong_query_time=2'
		'\nlog-slow-queries= /usr/local/mysql/log/slowquery.log')
        print "已经成功安装并加入系统启动命令···"

def mysql5():
	print "环境清理中···"
	commands.getstatusoutput(" yum erase mariadb mariadb-server mariadb-libs mariadb-devel -y")
	commands.getstatusoutput("yum remove mariadb -y ")
	commands.getstatusoutput("yum -y install make gcc-c++ cmake bison-devel  ncurses-devel perl ")
	commands.getstatusoutput("groupadd mysql && useradd -r -g mysql -s /bin/fales mysql")
	os.chdir ("/usr/local")
	print "准备安装···"
	if os.path.isfile(m_name) == True:
		print "本地已经存在5.5.gz无需下载"
	else:
		commands.getstatusoutput("wget https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz")
	print "正在解压安装包···"
	commands.getstatusoutput("tar vzxf mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz")
	shutil.move("mysql-5.5.62-linux-glibc2.12-x86_64","mysql")
	os.chdir ("/usr/local/mysql")
	print "开始安装···"
	print "时间较久，请耐心等候···"
	commands.getstatusoutput("./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data")	
	jnsystem()
def mysql6():
	print "环境清理中···"
        commands.getstatusoutput("yum erase mariadb mariadb-server mariadb-libs mariadb-devel -y")
        commands.getstatusoutput("yum remove mariadb -y")
        commands.getstatusoutput("yum -y install make gcc-c++ cmake bison-devel  ncurses-devel perl ")
        commands.getstatusoutput("groupadd mysql && useradd -r -g mysql -s /bin/fales mysql")
        os.chdir ("/usr/local")
        print "准备安装···"
        if os.path.isfile(m2_name) == True:
                print "本地已经存在5.6.gz无需下载"
        else:
                commands.getstatusoutput("wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.44-linux-glibc2.12-x86_64.tar.gz")
        print "正在解压安装包···"
        commands.getstatusoutput("tar vzxf mysql-5.6.44-linux-glibc2.12-x86_64.tar.gz")
	commands.getstatusoutput("rm -rf mysql")
        shutil.move("mysql-5.6.44-linux-glibc2.12-x86_64","mysql-5.6.44")
        os.chdir ("/usr/local/mysql")
        print "开始安装···"
        print "时间较久，请耐心等候···"
	commands.getstatusoutput("./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data")
	jnsystem()
def mysql7():
	print "环境清理中···"
        commands.getstatusoutput("yum erase mariadb mariadb-server mariadb-libs mariadb-devel -y")
        commands.getstatusoutput("yum remove mariadb -y")
        commands.getstatusoutput("yum -y install make gcc-c++ cmake bison-devel  ncurses-devel perl ")
        commands.getstatusoutput("groupadd mysql && useradd -r -g mysql -s /bin/fales mysql")
        os.chdir ("/usr/local")
        print "准备安装···"
        if os.path.isfile(m3_name) == True:
                print "本地已经存在5.7.26无需下载"
        else:
                commands.getstatusoutput("wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar")
        print "正在解压安装包···"
        commands.getstatusoutput("tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar")
	commands.getstatusoutput("tar xf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz")
        commands.getstatusoutput("rm -rf mysql")
        shutil.move("mysql-5.7.26-linux-glibc2.12-x86_64","mysql")
        os.chdir ("/usr/local/mysql")
        print "开始安装···"
        print "时间较久，请耐心等候···" 
        commands.getstatusoutput("chown -R  mysql:mysql /usr/local/mysql")
	commands.getstatusoutput("./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data")
	jnsystem()
def methods():
	print "#############################################################"
	print "######################  启动方式 ############################"   
	print "#############################################################"
	print "####                                                   ######"
	print "################## service mysql start ######################"
	print "####                                                   ######"
	print "########################  或者  #############################"
	print "####                                                   ######"
	print "#### /usr/local/mysql/support-files/mysql.server start ######"
	print "####                                                   ######"
	print "######################################################## ####"
def Minstall():
	print "###############可安装版本###############"
	print "###### A :5.5    B :5.6  C: 5.7 ########"
	print "################   R：返回 #############"
	print "########################################"
	while True:
		Inp = raw_input ("请输入你的选择A/B/C:")
		if Inp == A or Inp == a:
			mysql5()
		elif Inp == B or Inp == b:
			mysql6()
		elif  Inp == C or Inp == c:
		        mysql7()
		elif Inp == R or Inp == r:
			function()
		else: 
			print "输入错误，请重新输入"
			continue 	
		print "安装成功"
		time.sleep(1)
		print "启动方式如下:"
		methods()		
		time.sleep(5)
		print "感谢使用···"
		sys.exit()
def Mremove():
	if os.path.isdir(m_p) == True:
		shutil.rmtree(m_p)
	else:
		print "没有mysql目录···"
	if os.path.isfile(m_fp) == True:
		os.remove("/etc/my.cnf")
	else:
		print "没有my.cnf文件···"	
	commands.getstatusoutput("userdel mysql")
	print "成功删除···"
def function():
	print "################## A 安装 ################"
	print "################## B 卸载 ################"
	while True:
		inp = raw_input ("请选择选项:")
		if inp == A or inp == a:
			Minstall()
		elif inp == B or inp == b:
			Mremove()
			sys.exit()
		else:
			print "输入错误···"
			continue
function()