A Python GUI developed from PyQT5, to ease the process of ticket management connecting it to MySQL database locally.
import the database table structure into your MySQL workbench CE.
1.Create a new instance connection.
2.Note down your local-host port & password.
MySQLdb.connect(host='Port_Number', user='Username', password='Your_Password*', db='DB_name')
pip install PyMysqlDB
pip install PyQT5