PHP Warnings and issues with character set in MySQL 8

https://forum.howtoforge.com/threads/migrate-mysql-to-mariadb.90840/#post-447639