Yesterday I "upgraded" to mySQL 8.0.18 following the Jamf instructions https://www.jamf.com/jamf-nation/articles/698/title. Everything went really well but I followed the instructions too closely and when installing v8 I named my new DB and user "jamfpro", then I realized when I was restoring my DB from backup that my original DB name and user were "jamfsoftware" Now of course I have no DB connection. I opened a case with jamf yesterday but never heard back, I'm not sure if they were open. I really want to get my DB back online over the wkd if someone can help. Attached are a couple of jamfpro commands that might help with more info:
Solved
Botched mySQL Upgrade

Best answer by jared_f
I would just use the MySQL command to wipe out ("drop") the jamfpro database you created, then re-create the jamfsoftware database. Once your Jamf Tools are connected to the DB, restore from a backup and re-issue a Self Signed Cert (if you use one). If you are in SOS and need help doing this, email me - jflitt@caregivershomecare.com.
*Make sure you keep that backup of your DB safe (not on the server you host your Jamf on!).
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.