要使用mysql_native_password加密方法连接MySQL数据库,可以按照以下步骤进行操作:
-
安装MySQL驱动程序
pip install mysql-connector-python
-
导入必要的库
import mysql.connector
-
建立与MySQL数据库的连接
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
auth_plugin='mysql_native_password'
)
-
执行SQL查询
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM yourtable")
result = mycursor.fetchall()
for row in result:
print(row)
完整的示例代码如下所示:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
auth_plugin='mysql_native_password'
)
mycursor = mydb.cursor()
mycursor.execute("SELECT * FROM yourtable")
result = mycursor.fetchall()
for row in result:
print(row)
请确保将yourusername
和yourpassword
替换为实际的用户名和密码,并将yourtable
替换为实际的表名。