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 …