mysql批量授权脚本

最新推荐文章于 2024-07-19 03:28:37 发布

江南剑雨

最新推荐文章于 2024-07-19 03:28:37 发布

阅读量1.6k

点赞数 1

分类专栏： python 文章标签： python 授权

本文链接：https://blog.csdn.net/u011533425/article/details/45308015

版权

python 专栏收录该内容

24 篇文章 1 订阅

订阅专栏

#!/usr/bin/env python
#20150413
#grant mysql 
#!/usr/bin/python 
import paramiko
import sys
user="root"
dbuser=sys.argv[1]
dbname=sys.argv[2]
dbhost= sys.argv[3:]
def scm_db(ip):
                host=ip
                password='tty@ + '.'.join(host.split('.')[-2:])
                ssh = paramiko.SSHClient()
                ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
                ssh.connect(host,36000,user, password)
                dbhost= sys.argv[3:]
                for dbht in dbhost:
                        print dbht
                        cmd = 'echo "grant select on %s.*  to  %s@%s identified by \'%s\'"  |  mysql $sql_param' %(dbn
ame,dbuser,dbht,dbuser)

                        print cmd
                        stdin,stdout,stderr=ssh.exec_command(cmd)     
                        print stdout.read()
                        print stderr.read()
host=["192.168.1.2","192.168.1.3"]

for ip in host:
        print ip
        scm_db(ip)