There are some references in JAMF for how to set up MySQL 8 but I feel it is not centralized enough to be fully successful deploying on MySQL 8. This is just to condense it into a single post.

To start with, you will need to edit my.cnf and include

default-authentication-plugin=mysql_native_password

Now you will need to make sure your creation of mysql user includes the native password requirement.

mysql -uroot -p

mysql>CREATE USER 'jamfsoftware'@'localhost' IDENTIFIED WITH mysql_native_password BY 'jamfsw03';

At this point you should be good to go. Depending on how you are connecting to your mysql server, you might have to do aditional users for different IPs or networks.