Hey Vijay,

You need to import pymysql.

after this for connectivity.

def connection(self):

        hostname = self.host_name

        password = self.password

        dbname = self.db_name

        dbusername = self.db_user

        try:

            if self.connector == 'mysql':

                db_connection = pymysql.connect(

                    hostname, dbusername, password, dbname)

                cursor = db_connection.cursor()
                #For Query 

                cursor.execute("show tables;")

                datas = cursor.fetchall()

        # If connection is not successful

        except:

            self.env.user.notify_warning(message='Connection Failed !')

            return 0

        self.env.user.notify_success(message='Connection Successful !')

I Hope it will Useful for you.