python 数据库实践经验

pip install mysql-connector
mysql -u root -p

            import
             mysql.connector


            #
             change root password to yours:
            
#
             conn = mysql.connector.connect(user=‘root‘, password=‘password‘, database=‘test‘)
conn = mysql.connector.connect(user=‘root‘, password=‘‘, database=‘test‘)

cursor = conn.cursor()
# 创建user表:
# cursor.execute(‘create table user (id varchar(20) primary key, name varchar(20))‘)
# 插入一行记录，注意MySQL的占位符是%s:
cursor.execute(‘insert into user (id, name) values (%s, %s)‘, (‘3‘, ‘Michael‘))
print(‘rowcount =‘, cursor.rowcount)
# 提交事务:conn.commit()
cursor.close()

# 运行查询:
cursor = conn.cursor()
cursor.execute(‘select * from user where id = %s‘, (‘2‘,))
values = cursor.fetchall()
print(values)
# 关闭Cursor和Connection:cursor.close()
conn.close()

GRANT ALL PRIVILEGES ON * . * TO ‘root‘@‘localhost‘;
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘‘;