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
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.