1111下载安装mysql
2222pip 安装 建议使用PIP安装“MySQL Connector”。
其中报错
ProgrammingError: Access denied for user ‘root’@‘localhost’ (using password: YES)
报错后执行mysql命令
1.1:ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER; #修改加密规则
1.2:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
1.3:FLUSH PRIVILEGES; #刷新权限
1.4:再重置下密码:alter user 'root'@'localhost' identified by '123456';
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="你的用户名",
passwd="你的密码"
)
print(mydb)