{"id":304,"date":"2019-04-21T07:24:01","date_gmt":"2019-04-21T07:24:01","guid":{"rendered":"http:\/\/web.recologypower.com:9080\/?p=304"},"modified":"2019-09-08T14:29:36","modified_gmt":"2019-09-08T14:29:36","slug":"attributeerror-module-pymysql-has-no-attribute-connect","status":"publish","type":"post","link":"http:\/\/www.recologypower.com:9080\/?p=304","title":{"rendered":"AttributeError: module &#8216;pymysql&#8217; has no attribute &#8216;connect&#8217;"},"content":{"rendered":"<p>\u636e<a href=\"https:\/\/stackoverflow.com\/questions\/25395648\/connection-of-database-using-pymysql-in-python-3-x\">\u8fd9\u91cc<\/a>\u89e3\u91ca\u4e3a\u6587\u4ef6\u540d\u5b57\u548cpymysql module\u540d\u5b57\u91cd\u590d\u4e86\u3002\u9ebb\u86cb\uff0c\u539f\u6765\u8fd8\u8fd9\u4e48\u5f31\u667a\u3002<\/p>\n<pre class=\"brush:python\">Error\r\n\r\nconn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='', db='pymysql')\r\nAttributeError: 'module' object has no attribute 'connect'\r\ncode\r\n\r\nimport pymysql\r\n\r\nconn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='', db='pymysql')\r\n\r\ncur = conn.cursor()\r\n\r\ncur.execute(\"SELECT Host,User FROM user\")\r\n\r\nprint(cur.description)\r\n\r\nprint()\r\n\r\nfor row in cur:\r\n   print(row)\r\n\r\ncur.close()\r\nconn.close()<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"slide-text-bg2\">\n<h3>\u636e\u8fd9\u91cc\u89e3\u91ca\u4e3a\u6587\u4ef6\u540d\u5b57\u548cpymysql m<\/h3>\n<\/div>\n<div class=\"flex-btn-div\"><a href=\"http:\/\/www.recologypower.com:9080\/?p=304\" class=\"btn1 flex-btn\">\u9605\u8bfb\u66f4\u591a<\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[63,5],"tags":[],"_links":{"self":[{"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=\/wp\/v2\/posts\/304"}],"collection":[{"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=304"}],"version-history":[{"count":1,"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=\/wp\/v2\/posts\/304\/revisions"}],"predecessor-version":[{"id":305,"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=\/wp\/v2\/posts\/304\/revisions\/305"}],"wp:attachment":[{"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=304"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.recologypower.com:9080\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}