python连接数据库，提示找不到指定的win32模块 python import win32gui出错
\u95ee\u9898\uff1a\u5bfc\u5165Python\u6a21\u5757\uff0c\u65e0\u6cd5\u5bfc\u5165win32api\u6a21\u5757\uff1f\u8fd9\u4e2a\u6a21\u5757\u53ef\u80fd\u51fa\u73b0\u95ee\u9898\u4e86\uff0c\u4f60\u770b\u770b\u53ef\u4e0d\u53ef\u4ee5\u4e0a\u7f51\u91cd\u65b0\u4e0b\u4e00\u4e2a\u3002
\u8bf4\u660e\u6a21\u5757\u6ca1\u88c5\u6210\u529f\u30021\u3001\u8bf7\u5728https://sourceforge.net/projects/pywin32/files/pywin32/\u4e2d\u627e\u5230\u5408\u9002\u7248\u672c\u7684pywin32\u5b89\u88c5\u7a0b\u5e8f\u5e76\u4e0b\u8f7d\uff08\u6ce8\u610fWIN\u4f4d\u6570\u548cpython\u7248\u672c\uff0c\u9ad8\u7248\u672c\u5b89\u88c5\u4e0d\u5bb9\u6613\u6210\u529f\uff09\u30022\u3001\u53cc\u51fb\u5b89\u88c5\u30023\u3001pip install win32gui 4\u3001\u5982\u679c\u76f4\u63a5pip install win32gui\u5b89\u88c5\uff0c\u867d\u7136\u4f1a\u6210\u529f\uff0c\u4f46\u5728\u5b9e\u9645import\u65f6\u4f1a\u62a5 \u9519\uff08NameError\uff1aname 'win32gui' is not defined),\u4f30\u8ba1\u662f\u7f3a\u5c11\u76f8\u5e94\u7684dll\uff0c\u8bf7\u53c2\u8003https://stackoverflow.com/questions/3956178/cant-load-pywin32-library-win32gui
看一下：File “D:\Program
Files\Python2.6\Lib\site-packages\MySQLdb\__init__.py”
这个文件的第19行，看它在加载哪个dll时失败了。
然后看看你的系统中是否有这个dll，如果有，其路径是否包含在环境变量%PATH%中了。
需要下载libmmd.dll和libguide40.dll两个dll文件并复制到Python安装目录的Lib\site-packages下
http://files.cnblogs.com/yuxc/libguide40.dll.zip
http://files.cnblogs.com/yuxc/libmmd.dll.zip
python调用mysql需要安装相应的mysql扩展模块
登陆cmd,然后只要运行pip install mysqlclient一切搞定。
重新安装一下库
绛旓細閿欒鏄槑鏄庡彧鏀寔涓涓弬鏁扮殑锛屼絾鏄綘鍗翠紶浜嗕簲涓弬鏁般傚缓璁綘鐪嬫竻妤歱ymsql鐨凙PI
绛旓細杩欓噷鐨勬剰鎬濇槸锛鏁版嵁搴杩炰笉涓婂晩銆傚彲鑳芥槸缃戠粶闂锛屽彲鑳芥槸闃茬伀澧欓棶棰橈紝鍙兘鏄3306绔彛娌″紑銆備綘鍏堟帓闄よ繖浜涢棶棰樺惂銆傜敤涓浜沵ysql宸ュ叿杩炴帴娴嬭瘯鐪嬶紝姣斿SQLyog 娴嬭瘯銆
绛旓細鏂规硶涓锛氬湪oracle_home涓嬫壘鍒發snrctl.exe 杈撳叆 start 鏂规硶浜 鍙兘璁や笉鍒板疄渚嬪悕 鍦╟md涓嬭繍琛 set oracle_sid=鑷繁鏁版嵁搴鐨勫疄渚嬪悕锛堝ぇ澶氭暟orcl锛夌綉涓婅繕鏈夊緢澶氳В鍐冲姙娉 涔熻涓嶈寰楃鐢紝杩欑闂鍏蜂綋闂鍏蜂綋鍒嗘瀽姣旇緝濂姐備粙缁嶇殑杩2绉嶆偍鐨勬満鍣ㄨ繕涓嶈銆傚氨鍘讳慨鏀逛竴涓猅NSNAMES.ORA銆
绛旓細妫楠屽畨瑁呭畨瑁呮槸鍚︽垚鍔熺殑鏂规硶锛歩mport pymysql 銆 濡傛灉涓嶆姤閿 璇存槑瀹夎鎴愬姛銆3銆乵ysql瀹夎鐩綍涓篋:/phpStudy/MySQL銆備负閬垮厤鏇村閰嶇疆闂锛屽彲鍦ㄥ惎鍔╬hpstudy鍚庯紝灏嗗叾璁句负绯荤粺鏈嶅姟 4銆佸熀鏈搷浣滐細锛1锛夊鍏ymysql: import pymysql 锛2锛杩炴帴鏁版嵁搴锛歝onn=pymysql.connect(host='localhost',user='root'...
绛旓細妫楠屽畨瑁呭畨瑁呮槸鍚︽垚鍔熺殑鏂规硶锛歩mport pymysql 銆 濡傛灉涓嶆姤閿 璇存槑瀹夎鎴愬姛銆3銆乵ysql瀹夎鐩綍涓篋:/phpStudy/MySQL銆備负閬垮厤鏇村閰嶇疆闂锛屽彲鍦ㄥ惎鍔╬hpstudy鍚庯紝灏嗗叾璁句负绯荤粺鏈嶅姟 4銆佸熀鏈搷浣滐細锛1锛夊鍏ymysql: import pymysql 锛2锛杩炴帴鏁版嵁搴锛歝onn=pymysql.connect(host='localhost',user='root'...
绛旓細1.杩涘叆mysql鏁版嵁搴锛歮ysql> use mysql; Database changed 2.缁檙oot鐢ㄦ埛璁剧疆鏂板瘑鐮侊紝钃濊壊閮ㄥ垎鑷繁杈撳叆锛 mysql> update user set password=password("鏂板瘑鐮") where user="root"; Query OK, 1 rows affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 3.鍒锋柊鏁版嵁搴 mysql> flush ...
绛旓細2. 鍦ㄢ滆繛鎺ュ埌鏁版嵁鈥濋〉闈笂锛岄夋嫨瑕佽繛鎺ョ殑鏁版嵁绫诲瀷銆備篃鍙互閫夋嫨淇濆瓨鐨鏁版嵁杩炴帴锛圱DS 鏂囦欢锛夋墦寮涓涓 Tableau Server 鏁版嵁婧愩3. 杩炴帴鍒版暟鎹殑鍙︿竴绉嶆柟寮忔槸浠庡伐浣滅翱瀵煎叆銆傚伐浣滅翱鍙互鍖呭惈涓庝笉鍚屾暟鎹簮鐨勫涓繛鎺ャ傝嫢瑕佷粠宸ヤ綔绨垮鍏杩炴帴锛璇峰湪鈥滆繛鎺ュ埌鏁版嵁鈥濆璇濇涓崟鍑烩滈夋嫨淇濆瓨鐨勮繛鎺モ濋夐」鍗″簳閮ㄧ殑...
绛旓細妫楠屽畨瑁呭畨瑁呮槸鍚︽垚鍔熺殑鏂规硶锛歩mport pymysql 銆 濡傛灉涓嶆姤閿 璇存槑瀹夎鎴愬姛銆3銆乵ysql瀹夎鐩綍涓篋:/phpStudy/MySQL銆備负閬垮厤鏇村閰嶇疆闂锛屽彲鍦ㄥ惎鍔╬hpstudy鍚庯紝灏嗗叾璁句负绯荤粺鏈嶅姟 4銆佸熀鏈搷浣滐細锛1锛夊鍏ymysql: import pymysql 锛2锛杩炴帴鏁版嵁搴锛歝onn=pymysql.connect(host='localhost',user='root'...
绛旓細鏈枃瀹炰緥璁茶堪浜python杩炴帴oracle鏁版嵁搴鐨勬柟娉曪紝鍒嗕韩缁欏ぇ瀹朵緵澶у鍙傝冦傚叿浣撴楠ゅ涓嬶細涓銆侀鍏堜笅杞介┍鍔細锛坈x_Oracle锛塰ttp://www.python.net/crew/atuining/cx_Oracle/ 涓嶈繃瑕佹敞鎰忎竴涓嬬増鏈紝鏍规嵁浣犵殑鎯呭喌鍔犱互閫夋嫨銆備簩銆佸畨瑁咃細棣栧厛閰嶇疆oracle_home鐜鍙橀噺 鎵ц閭ｄ釜exe瀹夎绋嬪簭灏卞彲浠ヤ簡锛屽畠浼歝opy涓涓猚x_...
绛旓細妫楠屽畨瑁呭畨瑁呮槸鍚︽垚鍔熺殑鏂规硶锛歩mport pymysql 銆 濡傛灉涓嶆姤閿 璇存槑瀹夎鎴愬姛銆3銆乵ysql瀹夎鐩綍涓篋:/phpStudy/MySQL銆備负閬垮厤鏇村閰嶇疆闂锛屽彲鍦ㄥ惎鍔╬hpstudy鍚庯紝灏嗗叾璁句负绯荤粺鏈嶅姟 4銆佸熀鏈搷浣滐細锛1锛夊鍏ymysql: import pymysql 锛2锛杩炴帴鏁版嵁搴锛歝onn=pymysql.connect(host='localhost',user='root',...
