title: Installing mysql in PyCharm community edition
body: <p>I wasn't able to find this question asked before and this is driving me crazy. If this question is a duplicate, I'd appreciate it if someone could point me to an answer.</p>
  
  <p>I tried to install mysql (using <code>pip install mysql</code>) in the PyCharm terminal using Python 3.6. This is the error I get. I already updated pip to the latest version.</p>
  
  <blockquote>
    <p>Command "C:\Users\David\PycharmProjects\cryptocurrency2\cryptocurrencytrading\Scripts\python.exe -u -c "import setuptools, tokenize;<strong>file</strong>='C:\Users\David\AppData\Local\Temp\pip-install-alqyprfu\mysqlclient\setup.py';f=getattr(tokenize, 'open', open)(<strong>f
    ile</strong>);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, <strong>file</strong>, 'exec'))" install --record C:\Users\David\AppData\Local\Temp\pip-record-gcaxj074\install-record.txt --single-version-externally-managed --compile --install-headers C:\Users\David\PycharmProjects\cryptocurrency2\cryptocurrencytrading\include\site\python3.6\mysqlclient" failed with error code 1 in C:\Users\David\AppData\Local\Temp\pip-install-alqyprfu\mysqlclient\
    You are using pip version 10.0.1, however version 18.1 is available.
    You should consider upgrading via the 'python -m pip install --upgrade pip' command.</p>
  </blockquote>