db=mysqldb.connect（“localhost”，“root”，“reverend”，“testdb”）

当然，您可以这样做。但它不建议。并且您的代码有一些错误，例如 Sl_No. 列名称无效。所以我把你的密码改了一点。

import MySQLdb
import time
import datetime
import calendar
localtime = time.asctime(time.localtime(time.time()))
print ("Local current time :", localtime)
db = MySQLdb.connect("localhost","root","","attendence" )
cursor = db.cursor()
subject = raw_input("Enter Subject Name:")
cursor.execute("show tables")
dele = "DROP TABLE IF EXISTS {tab}".format(tab=subject)
cre  = """CREATE TABLE {tab} (Sl_No INT(200),NAME CHAR(20))""".format(tab=subject)

def commit(sql):
    cursor.execute(sql)
    db.commit()

if subject.strip() in [tab[0] for tab in cursor.fetchall()]:
    commit(dele)
    commit(cre)
else:
    commit(cre)
db.close()