WL#10353: Use utf8mb4 in libmysql and command tools

Affects: Server-8.0   —   Status: Complete

Libmysql uses a default compiled in character set for when auto-detecting the
environment settings fails. 
And it will switch to utf8mb3 for environments that use UTF8. 
On top of the some client tools will do their own inference and set the
connection charset according to the outcome of it. 

This worklog is about switching the compiled in default to utf8mb4 and making
sure that both libmysql's and client tools' autodetection picks utf8mb4 instead
of utf8mb3.

User Documentation
==================

* https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-2.html
* https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
* https://dev.mysql.com/doc/refman/8.0/en/mysql-real-connect.html