Python如何实现MySQL实例初始化详解
前言
相信每位程序员对mysql应该都不陌生，MySQL是一个关系型数据库管理系统，由瑞典MySQLAB公司开发，目前属于Oracle旗下产品。我们在日常开发中少不了要接触mysql。
腾讯云上的mysql实例，初始化的时候，需要自己点击“初始化按钮”，然后还要手动输入16位复杂的密码，这个操作比较繁琐，而且如果你一次建立多个实例，这个操作量就很大了，所以必须想办法提高效率，于是就有了下文，批量调用sdkapi来实现。
本文主要给大家介绍了关于Python实现MySQL实例初始化的相关内容，分享出来供大家参考学习，下面话不多说了，来一起看看详细的介绍吧。
示例代码
代码准备：initstance.py
#!/usr/bin/python
fromsrc.QcloudApi.qcloudapiimportQcloudApi
fromtimeimportctime,sleep
fromgetpwdimportget_password
definitinstance(cdbid,no):
module='cdb'
action='CdbMysqlInit'
config={
'Region':'ap-shanghai',
'secretId':'AKIDTsEEl8ZK9mHcotf4OYk2A7uYxxxxxxxx',
'secretKey':'IOI0Zw87vYDvhR6a5QZXouomxxxxxxxx',
'method':'get'
}
pwd=get_password(16)
params={
'cdbInstanceId':cdbid,
'charset':'utf8mb4',
'port':3306,
'lowerCaseTableNames':1,
'password':pwd
}
printparams
try:
service=QcloudApi(module,config)
printservice.generateUrl(action,params)
printservice.call(action,params)
exceptException,e:
print'exception:',e
defmain():
#这里添加N多实例id，可以批量进行初始化，不用再界面点击操作了。
cdbids_hermes=["cdb-1hz14ogho","cdb-1417ds7su"]
forindex,valueinenumerate(cdbids_hermes):
initinstance(value,str((index+1)).zfill(2))
sleep(1)
if__name__=='__main__':
main()
初始化实例脚本initstance.py，准备执行代码：
调试报错，需要安装qcloudapi-sdk-python-master.zip
[hy@orcl]/data0/dbj1st$pythoninitstance.py Traceback(mostrecentcalllast): File"initstance.py",line2,infromsrc.QcloudApi.qcloudapiimportQcloudApi ImportError:Nomodulenamedsrc.QcloudApi.qcloudapi [hy@orcl]/data0/dbj1st$ [hy@orcl]/data0/dbj1st/promotion$unzipqcloudapi-sdk-python-master.zip Archive:qcloudapi-sdk-python-master.zip e6cb9ff252cdb125e516525a2bb62d3410723adf creating:qcloudapi-sdk-python-master/ extracting:qcloudapi-sdk-python-master/.gitignore inflating:qcloudapi-sdk-python-master/README.md inflating:qcloudapi-sdk-python-master/demo.py creating:qcloudapi-sdk-python-master/src/ creating:qcloudapi-sdk-python-master/src/QcloudApi/ extracting:qcloudapi-sdk-python-master/src/QcloudApi/__init__.py creating:qcloudapi-sdk-python-master/src/QcloudApi/common/ extracting:qcloudapi-sdk-python-master/src/QcloudApi/common/__init__.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/common/request.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/common/sign.py creating:qcloudapi-sdk-python-master/src/QcloudApi/modules/ extracting:qcloudapi-sdk-python-master/src/QcloudApi/modules/__init__.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/account.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/base.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/bill.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/bm.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/cbs.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/cdb.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/cdn.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/cmem.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/cvm.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/dfw.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/eip.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/image.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/lb.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/live.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/market.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/monitor.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/redis.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/scaling.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/sec.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/snapshot.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/tdsql.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/trade.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/vod.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/vpc.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/wenzhi.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/modules/yunsou.py inflating:qcloudapi-sdk-python-master/src/QcloudApi/qcloudapi.py extracting:qcloudapi-sdk-python-master/src/__init__.py [hy@orcl]/data0/dbj1st/promotion$ll [hy@orcl]/data0/dbj1st/promotion$cp-rqcloudapi-sdk-python-master/src. [hy@orcl]/data0/dbj1st/promotion$
需要安装cassdk
[hy@orcl]/data0/dbj1st/promotion$pythoninitstance.py
6
exception:Nomodulenamedrequests
[hy@orcl]/data0/dbj1st/promotion$
[hy@orcl]/data0/dbj1st/promotion$
[hy@orcl]/data0/dbj1st/promotion$sudosu
[root@dbj4st]/data0/dbj1st/promotion$pipinstallcassdk
Collectingcassdk
Downloadingcassdk-1.0.2.tar.gz
Buildingwheelsforcollectedpackages:cassdk
Runningsetup.pybdist_wheelforcassdk...error
Completeoutputfromcommand/bin/python-u-c"importsetuptools,tokenize;__file__='/tmp/pip-build-1_XMv6/cassdk/setup.py';f=getattr(tokenize,'open',open)(__file__);code=f.read().replace('\r\n','\n');f.close();exec(compile(code,__file__,'exec'))"bdist_wheel-d/tmp/tmpzGF2_Dpip-wheel---python-tagcp27:
usage:-c[global_opts]cmd1[cmd1_opts][cmd2[cmd2_opts]...]
or:-c--help[cmd1cmd2...]
or:-c--help-commands
or:-ccmd--help
error:invalidcommand'bdist_wheel'
----------------------------------------
Failedbuildingwheelforcassdk
Runningsetup.pycleanforcassdk
Failedtobuildcassdk
Installingcollectedpackages:cassdk
Runningsetup.pyinstallforcassdk...done
Successfullyinstalledcassdk-1.0.2
[root@dbj4st]/data0/dbj1st/promotion$
需要安装requests
[hy@orcl]/data0/dbj1st/promotion$pythoninitstance.py 6 exception:Nomodulenamedrequests [hy@orcl]/data0/dbj1st/promotion$sudosu [root@dbj4st]/data0/dbj1st/promotion$sudopipinstall--upgradeurllib3 Collectingurllib3 Downloadingurllib3-1.22-py2.py3-none-any.whl(132kB) 100%|████████████████████████████████|133kB186kB/s Installingcollectedpackages:urllib3 Successfullyinstalledurllib3-1.22 [root@dbj4st]/data0/dbj1st/promotion$ [hy@orcl]/data0/dbj1st/promotion$sudosu [root@dbj4st]/data0/dbj1st/promotion$sudopipinstall--upgraderequests Collectingrequests Downloadingrequests-2.18.4-py2.py3-none-any.whl(88kB) 100%|████████████████████████████████|92kB9.9kB/s Collectingcertifi>=2017.4.17(fromrequests) Downloadingcertifi-2017.7.27.1-py2.py3-none-any.whl(349kB) 100%|████████████████████████████████|358kB36kB/s Collectingchardet<3.1.0,>=3.0.2(fromrequests) Downloadingchardet-3.0.4-py2.py3-none-any.whl(133kB) 100%|████████████████████████████████|143kB18kB/s Collectingidna<2.7,>=2.5(fromrequests) Downloadingidna-2.6-py2.py3-none-any.whl(56kB) 100%|████████████████████████████████|61kB16kB/s Requirementalreadyup-to-date:urllib3<1.23,>=1.21.1in/usr/lib/python2.7/site-packages(fromrequests) Installingcollectedpackages:certifi,chardet,idna,requests Foundexistinginstallation:chardet2.2.1 Uninstallingchardet-2.2.1: Successfullyuninstalledchardet-2.2.1 Successfullyinstalledcertifi-2017.7.27.1chardet-3.0.4idna-2.6requests-2.18.4 [root@dbj4st]/data0/dbj1st/promotion$
需要安装DependencyWarning
[laobanzhang@dbj1st]~/dbj1st/promotion$pythoninitstance.py 6 exception:cannotimportnameDependencyWarning [laobanzhang@dbj1st]~/dbj1st/promotion$
OK，执行成功：
[hy@orcl]/data0/dbj1st/promotion$pythoninitstance.py
6
7
{"code":0,"message":"","codeDesc":"Success","jobId":51783}
[hy@orcl]/data0/dbj1st/promotion$
总结
以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作具有一定的参考学习价值，如果有疑问大家可以留言交流，谢谢大家对毛票票的支持。