求教，python3怎么通过SSH隧道连接mysql数据库并执行SQL操作 python 怎样建立ssh连接 并登陆mysql
\u6c42\u6559\uff0cpython3\u600e\u4e48\u901a\u8fc7SSH\u96a7\u9053\u8fde\u63a5mysql\u6570\u636e\u5e93\u5e76\u6267\u884cSQL\u64cd\u4f5cpython3\u53d1\u5e03\u4ee5\u6765\uff0c\u83b7\u53d6\u4e86\u5e7f\u5927\u7a0b\u5e8f\u5458\u4eec\u7684\u5dee\u8bc4\uff0c\u8bf4\u4e0d\u7a33\u5b9a\uff0c\u53c8\u662f\u4e0d\u517c\u5bb9\u4ec0\u4e48\u7684\uff0c\u4e0d\u8fc7\u5dee\u8bc4\u5f52\u5dee\u8bc4\uff0cpython3\u65e2\u7136\u5df2\u7ecf\u53d1\u5e03\uff0c\u80af\u5b9a\u662f\u4e2a\u8d8b\u52bf\uff0c\u4f46\u5728python3.4\u91cc\u9762\uff0c\u4f7f\u7528\u539f\u6765python2.7\u7684mysqldb\u5df2\u7ecf\u4e0d\u80fd\u8fde\u63a5mysql\u6570\u636e\u5e93\u4e86\uff0c\u6bd4\u8f83\u4ee4\u4eba\u7ea0\u7ed3\uff0c\u4e0d\u8fc7\u6211\u4eec\u53ef\u4ee5\u4f7f\u7528pymysql\uff0c\u6765\u5b8c\u6210\u8fde\u63a5mysql\u7684\u91cd\u4efb\uff0c\u6b65\u9aa4\u5982\u4e0b\uff1a\u5e8f\u53f7\u63cf\u8ff01\u53bbgithub\u4e0a\u4e0b\u8f7dpymysql\u7684\u5b89\u88c5\u5305pymysql2\u89e3\u538b\u5230\u67d0\u4e2a\u76d8\u7b26\u4e0b3\u6253\u5f00cmd\u7a97\u53e3\uff08win\u73af\u5883\u4e0b\uff09\uff0c\u8fdb\u5165pymysql\u7684\u6839\u76ee\u5f55\u4e0b\u6267\u884c\u547d\u4ee4\uff0cpythonsetup.pyinstall4\u5728\u7a0b\u5e8f\u91cc\uff0c\u5bfc\u5165pymysql5\u5f00\u59cb\u8fde\u63a5\u6570\u636e\u5e93\u6570\u636e\u5e93\u64cd\u4f5c\u7684API\u6587\u6863\u8fde\u63a5:\u4ee3\u7801\u5982\u4e0b\uff1a__author__='qindongliang'#\u5bfc\u5165pymysql\u7684\u5305importpymysqltry:#\u83b7\u53d6\u4e00\u4e2a\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u6ce8\u610f\u5982\u679c\u662fUTF-8\u7c7b\u578b\u7684\uff0c\u9700\u8981\u5236\u5b9a\u6570\u636e\u5e93conn=pymysql.connect(host='localhost',user='root',passwd='qin',db='person',port=3306,charset='utf8')cur=conn.cursor()#\u83b7\u53d6\u4e00\u4e2a\u6e38\u6807cur.execute('select*fromperson')data=cur.fetchall()fordindata:#\u6ce8\u610fint\u7c7b\u578b\u9700\u8981\u4f7f\u7528str\u51fd\u6570\u8f6c\u4e49print("ID:"+str(d[0])+'\u540d\u5b57\uff1a'+d[1]+"\u6027\u522b\uff1a"+d[2])cur.close()#\u5173\u95ed\u6e38\u6807conn.close()#\u91ca\u653e\u6570\u636e\u5e93\u8d44\u6e90exceptException:print("\u53d1\u751f\u5f02\u5e38")\u7ed3\u679c\u5982\u4e0b\uff1aD:\python\python.exeD:/pythonide/pythonprojectworkspace/python/mysql.pyID:1\u540d\u5b57\uff1a\u79e6\u5929\u6027\u522b\uff1a\u7537ID:2\u540d\u5b57\uff1a\u738b\u6676\u6027\u522b\uff1a\u5973Processfinishedwithexitcode0
\u5b9e\u4f8b1\uff1aparamiko\u6a21\u5757
#!/usr/bin/python
import paramiko
ssh = paramiko.SSHClient()
ssh.set_missing_host_key_policy(paramiko.AutoAddPolicy())
ssh.connect("172.16.1.3",22,"root","333333")
stdin, stdout, stderr = ssh.exec_command("mysql -uroot -p123456 -Dmysql -e 'select user from user'")
print stdout.readlines()
ssh.close()
\u5b9e\u4f8b2:\u7528MySQLdb\u6a21\u5757\u64cd\u4f5cMySQL\u6570\u636e\u5e93\u975e\u5e38\u65b9\u4fbf
#!/usr/bin/python
import os, sys
import MySQLdb
try:
conn MySQLdb.connect(host='172.16.1.3',user='root',passwd='123456\u2019,db='address')
except Exception,e:
print e
sys.exit()
cursor=conn.cursor()
sql=\u2019insert into address(name, address) values(%s, %s)\u2019
value=((\u201czhangsan\u201d,\u201dhaidian\u201d),(\u201clisi\u201d,\u201dhaidian\u201d))
try
cursor.executemany(sql,values)
except Exception, e:
print e
sql=\u201dselect * from address\u201d
cursor.execute(sql)
data=cursor.fetchall()
if data
for x in data:
print x[0],x[1]
cursor.close()
conn.close()
绛旓細鍒氭墠鐨Python3鏄榛樿瀹夎甯sr/local/lib/python3.2鐩綍涓紝濡備笅 棣栧厛锛屽垹闄sr/bin/鐩綍涓嬬殑榛樿python link鏂囦欢銆傜劧鍚庢墦寮缁堢杈撳叆濡備笅鍛戒护琛岋紝寤虹珛鏂扮殑杩炴帴鍏崇郴 sudo ln -s /usr/bin/python3.2 /usr/bin/python 鎴愬姛 鐒跺悗娴嬭瘯涓涓媝ython鐗堟湰鏄惁姝ｇ‘ 鍛戒护琛岃緭鍏 python 鍗冲彲 ...
绛旓細Python 3.6.1 (default, Sep 7 2017, 16:36:03) [GCC 6.3.0 20170406] on linuxType "help", "copyright", "credits" or "license" for more information.>>> s = '123 456 7 4'>>> import re>>> a = re.findall(r'\d+', s)>>> a['123', '456', '7', '4']>...
绛旓細浠ｇ爜濡備笅 !/usr/bin/python3# -*- coding: utf-8 -*-s = input("璇疯緭鍏ヤ竴琛岄潪璐熸暣鏁帮紝浠ョ┖鏍奸殧寮锛-1缁撴潫:")# s = '1 67 56 78 -1'list1 = s.split()[:-1] list2 = []for line in list1: list2.append(int(line))print(list1)print(list2)
绛旓細鎸夌収浣犵殑瑕佹眰缂栧啓鐨勯嗗簭鏄剧ず瀛楃涓茬殑Python3绋嬪簭濡備笅 s = input("璇疯緭鍏ヤ竴涓瓧绗︿覆:")print(s[::-1]) #s[::-1]鐩稿綋浜巗[-1:-len(s)-1:-1],涔熷氨鏄粠鏈鍚庝竴涓厓绱犲埌绗竴涓厓绱犲鍒朵竴閬嶏紝鍗抽嗗簭
绛旓細浜.install pip for python3.x 棣栧厛瀹夎setuptools锛屼篃鏄閫氳繃瀹樻柟妯″潡搴撴潵涓嬭浇锛歨ttps://pypi.python.org/pypi杩欓噷鎴戝氨鐩存帴鐢╳get鍒版湇鍔″櫒涓婁笅杞戒簡鐗堟湰涓19.6锛堝皬浼欎即浠彲浠ュ皾璇曟柊鐨勭増鏈ゥ銆傘傦級wget --no-check-certificate https://pypi.python.org/packages/source/s/setuptools/setuptools-19.6....
绛旓細2銆佸垵瀛﹁呯殑璇濈‘瀹炲彲浠閫氳繃asciitable鏉ュ垽鏂瓧姣嶅拰鏁板瓧鐨勫尯鍒Python閲岄潰鏈変袱涓唴缃嚱鏁皁rd鍜宑hr鍙敤銆俛sciitable閫氳繃鍒ゆ柇鍏跺瓧鐨勮寖鍥存潵纭畾鏄瓧姣嶈繕鏄埆鐨勩傜‘瀹炲彲浠ヨ揪鍒颁綘鐜板湪鎯宠鐨勭洰鐨勩3銆乷ther))杈撳嚭锛氬瓧姣嶏細16鏁板瓧锛4鍏朵粬锛4涓嬮潰鏄疨ython鍐呯疆鍏充簬鍒ゆ柇瀛楃涓茬被鍨嬬殑鏂规硶浠嬬粛锛歴tr.isalnum()濡傛灉瀛楃涓蹭腑...
绛旓細(sqstack s) { if(s.top==0) { printf("underflow\n"); return 0; } else return s.stack[s.top]; } elemtype f(char c) { switch(c) { case '+': return 0; case '-': return 1; case '*': return 2; case '/': return 3; case '(': return 4; case ')': return 5; ...
绛旓細绛旀锛歴 = "Hello Python!"锛宻[3: 8] = "lo Py"瑙ｏ細s[3: 8] 琛ㄧず鐨勬槸鍒囩墖鎿嶄綔锛屾剰鎬濇槸鍙栬捣濮嬬储寮曪紙鍖呭惈璇ョ储寮曞搴斿硷級3锛缁堟绱㈠紩锛堜笉鍖呭惈璇ョ储寮曞搴斿硷級8 涔嬮棿鐨勫笺傜敱浜庡瓧绗︿覆 s 鐨勭涓涓瓧绗 H 鐨勭储寮曞兼槸 0锛屽洜姝ょ储寮曞 3 鐨勫瓧绗︽槸 l銆傚張鍥犵┖鏍间篃绠椾竴涓瓧绗︼紝鍥犳绱㈠紩鍊 8 ...
绛旓細2銆亀get http://www.python.org/ftp/python/3.2.3/Python-3.2.3.tar.bz2 3銆乼ar -xjf Python-3.2.3.tar.bz2 4銆乧d Python-3.2.3 5銆./configure --prefix=/usr/local/python3 6銆乵ake && make install 7銆乺m -rf /usr/bin/python 8銆乴n -s /usr/local/python3/bin/python3...
绛旓細Python鍔炲叕鑷姩鍖10涓珮棰戞搷浣 閬嶅巻鏂囦欢澶 鎵归噺鎿嶄綔鐨勫墠鎻愬氨鏄鏂囦欢澶硅繘琛岄亶鍘,浣跨敤S妯″潡鍙互杞绘澗鐨勯亶鍘嗘枃浠跺す,os.walk 閬嶅巻鍚庝骇鐢熶笁涓弬鏁: 1.褰撳墠鏂囦欢澶硅矾寰 2.鍖呭惈鏂囦欢澶瑰悕绉癧鍒楄〃褰㈠紡] 3.鍖呭惈鏂囦欢鍚嶇О[鍒楄〃褰㈠紡 浠ｇ爜濡備笅,澶у鍙互鏍规嵁鑷繁鐨勮矾寰勮繘琛屼慨鏀 褰撴墜涓婄殑闇姹傛槑纭湁鑾峰彇缁欏畾璺緞鍚勭骇鏂囦欢澶逛笅鎵鏈夌鍚堟潯...
