import sys,pymysql
import getpass
passwd=getpass.getpass(prompt=“Password:”)
conn=pymysql.connect(host=‘127.0.0.1’,user=‘root’,password=passwd,database=‘world’)
cur=conn.cursor()
try:
cur.execute(“select * from city”)
result=cur.fetchall()
for x in result:
print(x)
finally:
cur.close()
conn.close()