背景:CMD连接mysql正常,visual studio code里python连接mysql失败
代码:
CMD里:mysql -u qaz -p
enter password:*********
mysql>
visual studio code 里:
import mysql.connector
mydb=mysql.connector.connect(
host="localhost",
user="qaz",
passwd="**********",
#auth_plugin='mysql_native_password'
)
print(mydb)
visual studio code报错:
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user 'qaz'@'localhost' (using password: YES)
期望效果:visual studio code里python连接mysql正常