mysql.connector.errors.ProgrammingError: Character set 'utf8' unsupported 에러잡기

Flask로 백엔드를 구성하고 MariaDB를 연결하는 과정에서 아래와 같은 에러가 발생했다.

 

I encounter the following error: 
raise ProgrammingError(f"Character set '{charset}' unsupported")
mysql.connector.errors.ProgrammingError: Character set 'utf8' unsupported

 

해결방법

1.mysql-connector-python version을 다운그레이드하기

I have noticed, that my script does not work with mysql-connector-python==8.0.30 but does work with 8.0.28.

As a fast temporary fix I have downgraded mysql-connector-python version.

pip3 install mysql-connector-python==8.0.29