连接数据库的时候老报错,试了好多方法都不行。后来看到一篇文章,需要安装 MySQL 驱动程序,装完后就能连接上数据库了。文章:https://blog.csdn.net/weixin_51047454/article/details/123523930
。
安装数据库驱动:
python -m pip install mysql-connector
创建连接:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
passwd="yourpassword"
)
print(mydb)
创建数据库
import mysql.connector
mydb=mysql.connector.connect(
host="localhost",
user="yourusername",
passwd="yourpassword"
)
mycursor=mydb.cursor()
mycursor.execute("create database zdz")
检查数据库
import mysql.connector
mydb=mysql.connector.connect(
host="localhost",
user="yourusername",
passwd="yourpassword"
)
mycursor=mydb.cursor()
mycursor.execute("show databases")
for x in mycursor:
print(x)