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.
