前言

相信每位程序員對mysql應該都不陌生，MySQL是一個關系型數據庫管理系統，由瑞典MySQL AB 公司開發，目前屬于 Oracle 旗下產品。我們在日常開發中少不了要接觸mysql。

騰訊云上的mysql實例，初始化的時候，需要自己點擊“初始化按鈕”，然后還要手動輸入16位復雜的密碼，這個操作比較繁瑣，而且如果你一次建立多個實例，這個操作量就很大了，所以必須想辦法提高效率，于是就有了下文，批量調用sdk api來實現。

本文主要給大家介紹了關于Python實現MySQL實例初始化的相關內容，分享出來供大家參考學習，下面話不多說了，來一起看看詳細的介紹吧。

示例代碼

代碼準備：initstance.py

 #!/usr/bin/python from src.QcloudApi.qcloudapi import QcloudApi from time import ctime,sleep from getpwd import get_password def initinstance(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 } print params try:  service = QcloudApi(module, config)  print service.generateUrl(action, params)  print service.call(action, params) except Exception, e:  print 'exception:', e def main(): # 這里添加 N多實例id，可以批量進行初始化，不用再界面點擊操作了。 cdbids_hermes=["cdb-1hz14ogho","cdb-1417ds7su"] for index,value in enumerate(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$ python initstance.py  Traceback (most recent call last): File "initstance.py", line 2, in <module> from src.QcloudApi.qcloudapi import QcloudApi ImportError: No module named src.QcloudApi.qcloudapi [hy@orcl ] /data0/dbj1st$  [hy@orcl ] /data0/dbj1st/promotion$ unzip qcloudapi-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 -r qcloudapi-sdk-python-master/src . [hy@orcl ] /data0/dbj1st/promotion$