Mysql Connector python,NotSupportedError

to export a batch of Json data from Mongodb, you need to transfer to Mysql, but the exported Json format cannot be directly written to mysql, so you want to convert the data to Pandas"s dataframe, and then write to sql: through dataframe

.
import pandas as pd
from sqlalchemy import create_engine
import json


def json_to_sql(jsonfile, sqlname):
    df = pd.read_json(jsonfile, lines=True)
    conn = create_engine("mysql+mysqlconnector://root:123456@localhost:3306/ScientificName?charset=utf8")
    for i in range(len(df)):
        df["chromosomes"][i] = json.dumps(df["chromosomes"][i][0], ensure_ascii=False)
    print(df["chromosomes"][0])
    df.to_sql(name=sqlname, con=conn, if_exists="append", index=False)
        

json_to_sql("/Downloads/JSON-20180118/speciesHengduan.json", "speciesHengduan")

results always report errors at run time, and the mysql version used is 8.0.11:

NotSupportedError: (mysql.connector.errors.NotSupportedError) Authentication plugin "caching_sha2_password" is not supported (Background on this error at: http://sqlalche.me/e/tw8g)
Mar.13,2021

MySQL8 is not compatible with the earlier version here. You can reinstall MySQL (or use the Reconfigure option), set the authentication option to "Use Legacy Authentication Method", or downgrade to the lower version if you do not have to use MySQL8.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b2bcf8-2bad6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b2bcf8-2bad6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?