weixin_47226008的博客

python连接MySQL数据库import pymysql#导入pymysql库mysql_dict = { 'port': 3306, 'user':'root', 'host':'localhost', 'password':'123456', 'database':'userinfo'}db=pymysql.connect(**mysql_dict) #连接数据库cursor = db.cursor() #定义一个游标cursor.execute

navicat链接MySQL数据库报错解决办法如下mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';Query OK, 0 rows affected (0.02 sec)mysql> flush privileges;Query OK, 0 rows affected (0.02 sec)