none
How to install mysql package using VIsual Studio Code 2017? RRS feed

  • Question

  • While installing "MySQL" package using python in Visual Studio Code 2017, I am getting following error-

    Please let me help to install MySQL package using python in VC-2017 and help me to connect SQL database though it.

    Thanks !!

    Error - 

    >pip install mysql
    Collecting mysql
    Collecting MySQL-python (from mysql)
      Using cached MySQL-python-1.2.5.zip
    Building wheels for collected packages: MySQL-python
      Running setup.py bdist_wheel for MySQL-python ... error
      Complete output from command "C:\Program Files\Anaconda3\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\Dell\\AppData\\Local\\Temp\\pip-build-oqwmnfhy\\MySQL-python\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d C:\Users\Dell\AppData\Local\Temp\tmp7wowaklzpip-wheel- --python-tag cp36:
      running bdist_wheel
      running build
      running build_py
      creating build
      creating build\lib.win-amd64-3.6
      copying _mysql_exceptions.py -> build\lib.win-amd64-3.6
      creating build\lib.win-amd64-3.6\MySQLdb
      copying MySQLdb\__init__.py -> build\lib.win-amd64-3.6\MySQLdb
      copying MySQLdb\converters.py -> build\lib.win-amd64-3.6\MySQLdb
      copying MySQLdb\connections.py -> build\lib.win-amd64-3.6\MySQLdb
      copying MySQLdb\cursors.py -> build\lib.win-amd64-3.6\MySQLdb
      copying MySQLdb\release.py -> build\lib.win-amd64-3.6\MySQLdb
      copying MySQLdb\times.py -> build\lib.win-amd64-3.6\MySQLdb
      creating build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\__init__.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\CR.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\ER.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\FLAG.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\REFRESH.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      copying MySQLdb\constants\CLIENT.py -> build\lib.win-amd64-3.6\MySQLdb\constants
      running build_ext
      building '_mysql' extension
      creating build\temp.win-amd64-3.6
      creating build\temp.win-amd64-3.6\Release
      C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" "-IC:\Program Files\Anaconda3\include" "-IC:\Program Files\Anaconda3\include" "-IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\winrt" /Tc_mysql.c /Fobuild\temp.win-amd64-3.6\Release\_mysql.obj /Zl
      _mysql.c
      _mysql.c(42): fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory
      error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\x86_amd64\\cl.exe' failed with exit status 2
      ----------------------------------------
      Failed building wheel for MySQL-python
      Running setup.py clean for MySQL-python
    Failed to build MySQL-python
    Installing collected packages: MySQL-python, mysql
      Running setup.py install for MySQL-python ... error
        Complete output from command "C:\Program Files\Anaconda3\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\Dell\\AppData\\Local\\Temp\\pip-build-oqwmnfhy\\MySQL-python\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\Dell\AppData\Local\Temp\pip-8g__vzno-record\install-record.txt --single-version-externally-managed --compile:
        running install
        running build
        running build_py
        creating build
        creating build\lib.win-amd64-3.6
        copying _mysql_exceptions.py -> build\lib.win-amd64-3.6
        creating build\lib.win-amd64-3.6\MySQLdb
        copying MySQLdb\__init__.py -> build\lib.win-amd64-3.6\MySQLdb
        copying MySQLdb\converters.py -> build\lib.win-amd64-3.6\MySQLdb
        copying MySQLdb\connections.py -> build\lib.win-amd64-3.6\MySQLdb
        copying MySQLdb\cursors.py -> build\lib.win-amd64-3.6\MySQLdb
        copying MySQLdb\release.py -> build\lib.win-amd64-3.6\MySQLdb
        copying MySQLdb\times.py -> build\lib.win-amd64-3.6\MySQLdb
        creating build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\__init__.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\CR.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\FIELD_TYPE.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\ER.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\FLAG.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\REFRESH.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        copying MySQLdb\constants\CLIENT.py -> build\lib.win-amd64-3.6\MySQLdb\constants
        running build_ext
        building '_mysql' extension
        creating build\temp.win-amd64-3.6
        creating build\temp.win-amd64-3.6\Release
        C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /Ox /W3 /GL /DNDEBUG /MD -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 "-IC:\Program Files (x86)\MySQL\MySQL Connector C 6.0.2\include" "-IC:\Program Files\Anaconda3\include" "-IC:\Program Files\Anaconda3\include" "-IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.15063.0\winrt" /Tc_mysql.c /Fobuild\temp.win-amd64-3.6\Release\_mysql.obj /Zl
        _mysql.c
        _mysql.c(42): fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory
        error: command 'C:\\Program Files (x86)\\Microsoft Visual Studio 14.0\\VC\\BIN\\x86_amd64\\cl.exe' failed with exit status 2
        ----------------------------------------
    Command ""C:\Program Files\Anaconda3\python.exe" -u -c "import setuptools, tokenize;__file__='C:\\Users\\Dell\\AppData\\Local\\Temp\\pip-build-oqwmnfhy\\MySQL-python\\setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record C:\Users\Dell\AppData\Local\Temp\pip-8g__vzno-record\install-record.txt --single-version-externally-managed --compile" failed with error code 1 in C:\Users\Dell\AppData\Local\Temp\pip-build-oqwmnfhy\MySQL-python\

    Sunday, July 30, 2017 3:05 PM

All replies