mysql8.4版本，编码格式里面出现了新的charset=utf8mb4_0900_ai_ci

[shuirouyan]

连接抛出异常，requirement.txt里面的pymysql需要更新，异常信息如下：

(venv_binlog2sql) [scnf3npx40@login03 binlog2sql]$ python3 binlog2sql/binlog2sql.py -h127.0.0.1 -P13307 -uroot -p'Aa##123456' -dfastapidb -tbook --start-file='binlog.000002' --start-position=4 --stop-position='3008' > $HOME/raw.sql
Traceback (most recent call last):
  File "binlog2sql/binlog2sql.py", line 149, in <module>
    back_interval=args.back_interval, only_dml=args.only_dml, sql_type=args.sql_type)
  File "binlog2sql/binlog2sql.py", line 46, in __init__
    self.connection = pymysql.connect(**self.conn_setting)
  File "/public/home/scnf3npx40/code/venv_binlog2sql/lib64/python3.6/site-packages/pymysql/__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "/public/home/scnf3npx40/code/venv_binlog2sql/lib64/python3.6/site-packages/pymysql/connections.py", line 706, in __init__
    self.connect()
  File "/public/home/scnf3npx40/code/venv_binlog2sql/lib64/python3.6/site-packages/pymysql/connections.py", line 931, in connect
    self._get_server_information()
  File "/public/home/scnf3npx40/code/venv_binlog2sql/lib64/python3.6/site-packages/pymysql/connections.py", line 1269, in _get_server_information
    self.server_charset = charset_by_id(lang).name
  File "/public/home/scnf3npx40/code/venv_binlog2sql/lib64/python3.6/site-packages/pymysql/charset.py", line 38, in by_id
    return self._by_id[id]
KeyError: 255

[shuirouyan]

已更新pymysql的版本，可以正常解析了代码如下：

(venv_binlog2sql) [scnf3npx40@login03 binlog2sql]$ python3 binlog2sql/binlog2sql.py -h127.0.0.1 -P13307 -uroot -p'Aa##123456' -dtestdb -ttbl --start-file='binlog.000004' --start-position=4 --stop-position=1865 -B >  $PWD/analyze_sql/testdb_rollback.sql
(venv_binlog2sql) [scnf3npx40@login03 binlog2sql]$ less analyze_sql/testdb_rollback.sql 
(venv_binlog2sql) [scnf3npx40@login03 binlog2sql]$ less -N analyze_sql/testdb_rollback.sql 
(venv_binlog2sql) [scnf3npx40@login03 binlog2sql]$ pip list
Package           Version
----------------- -------
mysql-replication 0.13
pip               21.3.1
PyMySQL           0.9.3
setuptools        39.2.0
wheel             0.29.0
(venv_binlog2sql) [scnf3npx40@login03 binlog2sql]$