Traceback (most recent call last):
  File "/root/test.py", line 23, in <module>
    mysqlconnect()
  File "/root/test.py", line 6, in mysqlconnect
    conn = pymysql.connect(
  File "/opt/venv/lib/python3.9/site-packages/pymysql/connections.py", line 310, in __init__
    self.encoding = charset_by_name(self.charset).encoding
AttributeError: 'NoneType' object has no attribute 'encoding'

CREATE DATABASE db /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci */;

  
def mysqlconnect():
    # To connect MySQL database
    conn = pymysql.connect(
        host='localhost',
        user='root', 
        db='db',
        charset="utf8mb3"
        )
      
    cur = conn.cursor()
    cur.execute("select @@version")
    output = cur.fetchall()
    print(output)
      
    # To close the connection
    conn.close()
  
# Driver Code
if __name__ == "__main__" :
    mysqlconnect()