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.
I tried to install mysql (using pip install mysql) in the PyCharm terminal using Python 3.6. This is the error I get. I already updated pip to the latest version.

Command "C:\Users\David\PycharmProjects\cryptocurrency2\cryptocurrencytrading\Scripts\python.exe -u -c "import setuptools, tokenize;file='C:\Users\David\AppData\Local\Temp\pip-install-alqyprfu\mysqlclient\setup.py';f=getattr(tokenize, 'open', open)(f
  ile);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, '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.
try to use python -m pip install --upgrade pip
ur pip version is too low
Installing mysql in PyCharm community edition