MySQL and Python the easy way single script

mysql_python.py

# require: pip3 install mysql-connector-python
import mysql.connector
 
class MySQLManager:
    def __init__(self, host, user, passwd, database, port=3306):
        self.mydb = mysql.connector.connect(
            host=host,
            user=user,
            passwd=passwd,
            database=database,
            port=port,
            connect_timeout=30
        )
        self.mycursor = self.mydb.cursor()
    
    def create_table(self, table_query):
        self.mycursor.execute(table_query)
 
    def insert_data(self, insert_query, val):
        self.mycursor.execute(insert_query, val)
        self.mydb.commit()
 
    def select_data(self, select_query):
        self.mycursor.execute(select_query)
        return self.mycursor.fetchall()
 
    def update_data(self, update_query):
        self.mycursor.execute(update_query)
        self.mydb.commit()
 
    def delete_data(self, delete_query):
        self.mycursor.execute(delete_query)
        self.mydb.commit()
 
    def close_connection(self):
        self.mycursor.close()
        self.mydb.close()