I am creating python script in QGIS python console to be able to connect to mysql db and manipulate data (retrieve from db, generate shapefile and show it as a layer). I tried to install mysql connector from OSGeo4w shell: pip install mysql-connector-python but it fails with error:
C:>pip install mysql-connector-python Collecting mysql-connector-python C:\OSGEO4~1\apps\Python27\lib\site-packages\pip_vendor\requests\packages\urllib 3\util\ssl_.py:318: SNIMissingWarning: An HTTPS request has been made, but the S NI (Subject Name Indication) extension to TLS is not available on this platform. This may cause the server to present an incorrect TLS certificate, which can ca use validation failures. You can upgrade to a newer version of Python to solve t his. For more information, see https://urllib3.readthedocs.io/en/latest/security .html#snimissingwarning. SNIMissingWarning C:\OSGEO4~1\apps\Python27\lib\site-packages\pip_vendor\requests\packages\urllib 3\util\ssl_.py:122: InsecurePlatformWarning: A true SSLContext object is not ava ilable. This prevents urllib3 from configuring SSL appropriately and may cause c ertain SSL connections to fail. You can upgrade to a newer version of Python to solve this. For more information, see https://urllib3.readthedocs.io/en/latest/s ecurity.html#insecureplatformwarning. InsecurePlatformWarning Could not find a version that satisfies the requirement mysql-connector-python (from versions: ) No matching distribution found for mysql-connector-python
What is the best way to solve this?