I am trying to use mysql with python SQLAlchemy but while installing mysqlclient for python its giving error. kindly check details below:

I'm running this on Windows 10 64 bit and Anaconda Python 3.7.4
I have tried by installing another python version as well but no luck.
Tried to install MYSQL connector c++ as well. but still not working.
If I run code 'pip install mysqlclient'

mysql.c(29): fatal error C1083: Cannot open include file: 'mysql.h': No such file or directory error: command 'C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.14.26428\bin\HostX86\x64\cl.exe' failed with exit status 2
I just got an answer by looking at other options mentioned here.
Actually mistake was that,

I have installed Python 3.7.4 with 32 bits on 64bits machine.
Code was looking for below path but it was going to the wrong path in program files instead of program files(x86)

C:\Program Files (x86)\MySQL\MySQL Connector C 6.1\lib
I have installed a new Python with 3.7 with 64 bits and also while installing MySQL connector I have changed the path of installation to the above-mentioned path and now it's working fine.
Thank you, everyone, for your time and help
pip install mysqlclient on win64 not working giving error 'Cannot open file: 'mysql.h'