title: Loading the MySql module for Python 3.6 (Windows)
body: <p>I am trying to load the MySQL module in Python. However, I am having trouble getting started with this. My laptop is an Intel i5 with Windows 7.</p>
  
  <p>I have both Python 3.6 and 3.7 installed - both 64 bit versions. I started with 3.7 and Visual Studio added 3.6 so I switched to using 3.6 since the wheel for mysqlclient seemed to be for Python 3.6.
  I am using Pycharm IDE which I can use either versions of Python.</p>
  
  <h3>Installation via pip</h3>
  
  <p>I have tried <code>pip install mysqlclient</code> (calling from python directory) and I get the following error:</p>
  
  <pre><code>fatal error C1083: Cannot open include file mysql.h 
  </code></pre>
  
  <h3>Installation via wheel</h3>
  
  <p>If I try to use the wheel <code>mysqlclient-1.3.12-cp36-cp36m-win_amd64.whl</code>
  which I put in the python directory and call</p>
  
  <pre><code>pip install mysqlclient-1.3.12-cp36-cp36m-win_amd64.whl
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>mysqlclient-1.3.12-cp36-cp36m-win_amd64.whl is not a supported wheel on this platform.
  </code></pre>
  
  <h3>Other things I have tried</h3>
  
  <p>I installed Visual Studio 2017 as suggested in another response. That response suggest using Visual Studio 2015 though (would that make a difference)?</p>
  
  <p>I also tried the MySQL connector at <a href="https://dev.mysql.com/downloads/connector/python/" rel="nofollow noreferrer">https://dev.mysql.com/downloads/connector/python/</a>
  but this only seems to work with Python 3.4 and when run it is says <code>no Python 3.4 found</code>.</p>
  
  <p>So I am running out of ideas. I have looked at several other answers and hence tried some the things already. Any help would be gratefully received.</p>