I have not used MySQL very long - in fact I'm not sure I ever used 5.6, but I've used it a lot. And, there were big changes from 5.7 to 8.0 as well. Improvements, mostly, but some unexpected inconveniences too.
I run Ubuntu 18.04 which serves up 5.7, and in order to get MySQL 8.0 I had to use the Oracle repository after purging all 5.7 packages, and the effect it had on my workflow when coming from 5.7 basically came down to two things:
1) The ways users authenticate. Older versions use username/password and the default in 8.0 is "caching_sha2_password", so when users are created they can be established with "mysql_native_password" for the plugin field. The databases then accepts connections with username/password credentials.
2) A couple of times an 8.0 update has caused a mismatch/number of fields error and I get locked out. I have to follow this guide to restore access.