I want to get benchmark numbers with MySQL 8.0.11. This is my
first impression. The default auth method was changed to
caching_sha2_password. See this post for more details. There will be some
confusion with this change. By confusion I mean the difference
between "error" and "OK because cached" below. I am not alone.
See the experience that an expert had with replication.
Fun with caching_sha2_password occurs even with clients compiled
as part of 8.0.11:
- install MySQL 8.0.11, disable SSL but use mostly default my.cnf
- bin/mysql -u... -p... -h127.0.0.1 -e ... -> error
- bin/mysql -u... -p... -e ... -> OK …