{"id":826,"date":"2021-01-10T00:55:36","date_gmt":"2021-01-09T16:55:36","guid":{"rendered":"https:\/\/byy3.com\/?p=826"},"modified":"2021-01-10T00:55:36","modified_gmt":"2021-01-09T16:55:36","slug":"solved-python-version-problem-with-no-module-mysql-and-mysql-connector","status":"publish","type":"post","link":"https:\/\/byy3.com\/?p=826","title":{"rendered":"solved python version problem with no module mysql and mysql.connector"},"content":{"rendered":"<div class=\"votecell post-layout--left\">\n<div class=\"js-voting-container grid jc-center fd-column ai-stretch gs4 fc-black-200\" data-post-id=\"42124222\">\n<div class=\"js-vote-count grid--cell fc-black-500 fs-title grid fd-column ai-center\" data-value=\"105\">105<\/div>\n<p><button class=\"js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer\" data-controller=\"s-tooltip\" data-s-tooltip-placement=\"right\" aria-pressed=\"false\" aria-label=\"Down vote\" data-selected-classes=\"fc-theme-primary\" aria-describedby=\"--stacks-s-tooltip-7rwd1a9m\"><\/button><\/div>\n<\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\">\n<p>I was facing the similar issue. My env details - Python 2.7.11 pip 9.0.1 CentOS release 5.11 (Final)<\/p>\n<p>Error on python interpreter -<\/p>\n<pre class=\"default s-code-block hljs ruby\"><code>&gt;&gt;&gt; import mysql.connector\r\nTraceback (most recent call last):\r\n File <span class=\"hljs-string\">\"&lt;stdin&gt;\"<\/span>, line <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-keyword\">in<\/span> &lt;<span class=\"hljs-class\"><span class=\"hljs-keyword\">module<\/span>&gt;<\/span>\r\n<span class=\"hljs-symbol\">ImportError:<\/span> No <span class=\"hljs-class\"><span class=\"hljs-keyword\">module<\/span> <span class=\"hljs-title\">named<\/span> <span class=\"hljs-title\">mysql<\/span>.<span class=\"hljs-title\">connector<\/span><\/span>\r\n&gt;&gt;&gt;\r\n<\/code><\/pre>\n<p>Use pip to search the available module -<\/p>\n<pre class=\"default s-code-block hljs lua\"><code>$ pip search mysql-connector | grep <span class=\"hljs-comment\">--color mysql-connector-python<\/span>\r\n\r\n\r\n\r\nmysql-connector-python-rf (<span class=\"hljs-number\">2.2<\/span><span class=\"hljs-number\">.2<\/span>) - MySQL driver written <span class=\"hljs-keyword\">in<\/span> Python\r\nmysql-connector-python (<span class=\"hljs-number\">2.0<\/span><span class=\"hljs-number\">.4<\/span>) - MySQL driver written <span class=\"hljs-keyword\">in<\/span> Python\r\n<\/code><\/pre>\n<p>Install the mysql-connector-python-rf -<\/p>\n<pre class=\"default s-code-block hljs ruby\"><code><span class=\"hljs-variable\">$ <\/span>pip install mysql-connector-python-rf\r\n<\/code><\/pre>\n<p>Verify<\/p>\n<pre class=\"default s-code-block hljs dart\"><code>$ python\r\nPython <span class=\"hljs-number\">2.7<\/span><span class=\"hljs-number\">.11<\/span> (<span class=\"hljs-keyword\">default<\/span>, Apr <span class=\"hljs-number\">26<\/span> <span class=\"hljs-number\">2016<\/span>, <span class=\"hljs-number\">13<\/span>:<span class=\"hljs-number\">18<\/span>:<span class=\"hljs-number\">56<\/span>)\r\n[GCC <span class=\"hljs-number\">4.1<\/span><span class=\"hljs-number\">.2<\/span> <span class=\"hljs-number\">20080704<\/span> (Red Hat <span class=\"hljs-number\">4.1<\/span><span class=\"hljs-number\">.2<\/span><span class=\"hljs-number\">-54<\/span>)] <span class=\"hljs-keyword\">on<\/span> linux2\r\n<span class=\"hljs-built_in\">Type<\/span> <span class=\"hljs-string\">\"help\"<\/span>, <span class=\"hljs-string\">\"copyright\"<\/span>, <span class=\"hljs-string\">\"credits\"<\/span> or <span class=\"hljs-string\">\"license\"<\/span> <span class=\"hljs-keyword\">for<\/span> more information.\r\n&gt;&gt;&gt; <span class=\"hljs-keyword\">import<\/span> mysql.connector\r\n&gt;&gt;&gt;\r\n<\/code><\/pre>\n<p>Thanks =)<\/p>\n<p>For python3 and later use the next command: $<strong> pip3 install mysql-connector-python-rf<\/strong><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>105 I was facing the similar issue. My env details &#8211; Py [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[380,378,352,379],"class_list":["post-826","post","type-post","status-publish","format-standard","hentry","category-python","tag-python-mysql","tag-python"],"_links":{"self":[{"href":"https:\/\/byy3.com\/index.php?rest_route=\/wp\/v2\/posts\/826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/byy3.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/byy3.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/byy3.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/byy3.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=826"}],"version-history":[{"count":0,"href":"https:\/\/byy3.com\/index.php?rest_route=\/wp\/v2\/posts\/826\/revisions"}],"wp:attachment":[{"href":"https:\/\/byy3.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/byy3.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/byy3.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}