pip install --allow-external mysql-connector-python mysql-connector-python

Traceback (most recent call last):
  File "select.py", line 3, in <module>
    import mysql.connector
  File "C:UserspreetAppDataLocalProgramsPythonPython36libsite-packages
mysqlconnector__init__.py", line 37, in <module>
    from .connection import MySQLConnection
  File "C:UserspreetAppDataLocalProgramsPythonPython36libsite-packages
mysqlconnectorconnection.py", line 45, in <module>
    from .network import MySQLUnixSocket, MySQLTCPSocket
  File "C:UserspreetAppDataLocalProgramsPythonPython36libsite-packages
mysqlconnectornetwork.py", line 28, in <module>
    import socket
  File "C:UserspreetAppDataLocalProgramsPythonPython36libsocket.py", li
ne 52, in <module>
    import os, sys, io, selectors
  File "C:UserspreetAppDataLocalProgramsPythonPython36libselectors.py",
 line 11, in <module>
    import select
  File "C:UserspreetDesktopptyhon-newspaperselect.py", line 7, in <module>
    cnx = mysql.connector.connect(user='root', password='Jinqm21k',
AttributeError: module 'mysql' has no attribute 'connector'

from __future__ import print_function
from datetime import date, datetime, timedelta
import mysql.connector



cnx = mysql.connector.connect(user='root', password='Jinqm21k',
                              host='localhost',
                              database='worpress')
cursor = cnx.cursor()

query = ("SELECT first_name, last_name, hire_date FROM employees "
         "WHERE hire_date BETWEEN %s AND %s")

hire_start = datetime.date(1999, 1, 1)
hire_end = datetime.date(1999, 12, 31)

cursor.execute(query, (hire_start, hire_end))

for (first_name, last_name, hire_date) in cursor:
  print("{}, {} was hired on {:%d %b %Y}".format(
    last_name, first_name, hire_date))


cursor.close()
cnx.close()