如果host改为host=‘host’,会出现1045的错误,原因不清楚
import pymysql
host = '127.0.0.1'
username = 'root'
password = 'root'
db_name = 'mvcase'
create_table = """
create table tieba(title varchar(255) not null,
author varchar(255) not null,
content text not null)
"""
insert_table = """
insert into tieba(title,author,content) values('hallo_world','xiaoming','hahahahha')
"""
query_table = """
select * from tieba
"""
conn = pymysql.connect(host=host,user=username,password=password,charset='utf8',
db=db_name)
cursor = conn.cursor()
cursor.execute(create_table)
conn.commit()
cursor.execute(insert_table)
cursor.execute(query_table)
conn.commit()