I am starting with Python and did short script in VScode. When I try to run it I get this error:

PS C:\Users\spider> & C:/Python39/python.exe c:/Users/spider/drek.py
Traceback (most recent call last):
File "c:\Users\spider\drek.py", line 5, in <module>
import mysql.connector
ModuleNotFoundError: No module named 'mysql'

I ran pip install mysql-connector and it installed it. If I run pip list I get this:

PS C:\Users\spider> pip list

Package Version
---------------------- -------
mysql-connector 2.2.9
mysql-connector-python 8.0.24
pip 21.0.1
protobuf 3.15.8
six 1.15.0
wheel 0.36.2

PS C:\Users\spider>

Why I can't use MySql commands and how to fix it?

I'm testing with a log-in template I've downlaoded from Github and I want to modify it by having it create a database with my own fields and attributes. However, the code "imports pymysql" and from a video I've watched that discusses about this code, made by the person who wrote said code, it uses the MySQL terminal to view the database. I want to change it in a way that the database can be created and viewed in MySQL Workbench, as I'm more accustomed with that tool.

Here's a sample of the code where the database is created:

#######################################################################

import pymysql

def submit():

if firstnameEntry.get()=='' or lastnameEntry.get()=='' or emailentry.get()=='' or gender.get()=='' \

or variable1.get()=='' or usernameEntry.get()=='' or passwordEntry.get()=='' or \

renterpasswordEntry.get()=='':

messagebox.showerror('Alert!', 'All Fields must be entered') #this is to check if all the entry fields are

# empty if it is true it'll show a msgbox error

elif passwordEntry.get() != renterpasswordEntry.get():

messagebox.showerror('Alert!', 'Passwords didn\'t Match')

else:

db=pymysql.connect(host='localhost', user='root', password='1234')

cur=db.cursor()

#

#1st section

try:

query='create database p_registration'

cur.execute(query)

query='use p_registration'

cur.execute(query)

query='create table personaldata (id int auto_increment primary key not null, firstname varchar(40), ' \

'lastname varchar(40), email varchar(40), gender varchar(40), country varchar (40), ' \

'username varchar(40), passwrd varchar(10), ' \

'confirmpasswrd varchar(10))'

cur.execute(query)

# messagebox.showinfo('Success','Database was created successfully')

except:

cur.execute('use p_registration')

#2nd section

query='insert into personaldata(firstname, lastname, email, gender, country, username, passwrd, confirmpasswrd)' \

' values(%s,%s,%s,%s,%s,%s,%s,%s)'

cur.execute(query,(firstnameEntry.get(), lastnameEntry.get(), emailentry.get(), gender.get(), variable1.get(),

usernameEntry.get(),passwordEntry.get(), renterpasswordEntry.get()))

db.commit() #to execute the change

db.close()

messagebox.showinfo('Success', 'Successful Registration.')

#to clear the fields after a successful registration

firstnameEntry.delete(0, END)

lastnameEntry.delete(0, END)

emailentry.delete(0, END)

usernameEntry.delete(0, END)

passwordEntry.delete(0, END)

renterpasswordEntry.delete(0, END)

gender.set(0)

variable1.set('Select Country')

windows.destroy()

import loginpg

#######################################################################

What changes should I make to have it connect to MySQL workbench instead? Thanks in advance.