pip install oursql
import oursql
conn = oursql.connect(
host='localhost',
port=3306,
user='your_username',
passwd='your_password',
db='your_database'
)
2.1. ImportError: No module named 'oursql'
2.2. oursql.OperationalError: (2005, 'Unknown MySQL server host...')
2.3. oursql.ProgrammingError: (1044, "Access denied for user 'your_user'@'your_host' to database 'your_db'")
2.4. oursql.InterfaceError: (0, '')
import oursql
conn = oursql.connect(
host='localhost',
port=3306,
user='your_username',
passwd='your_password',
db='your_database'
)
cur = conn.cursor()
cur.execute("SELECT * FROM your_table")
rows = cur.fetchall()
for row in rows:
print(row)
conn.close()
