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

It looks like you are using a Mac for your host? Not sure about the command syntax. This is what I have used on my WIndows hosts in the past:
https://stackoverflow.com/questions/2050581/how-to-delete-mysql-database-through-shell-command

Thx @jared_f , Followed your advice to blow out the old DB and create a new one, I'm headed in the right direction. Now, when I try to start mySQL I get an error that I think is related to my.cnf (researching that now)

"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

@TomDay My quick research shows that means MySQL is not started. In that case, you would have to find the root cause for it not starting - in my experience a reboot sometimes fixes the issue. That being said, I use VM snapshots too.

Have you considered blowing out MySQL and re-installing it? As long as you have that DB Backup you will be fine. The only thing you will have to renew is the self signed cert.

Also may be something wacky with permissions. Seems like a botched MySQL install. I would go through the same procedure you did to upgrade it remove MySQL, re-install, re-create the jamfsoftware db.

I got mysql started and restoring the DB now. If I still have issues, I am going back tp the beginning and blowing out mySQL tomorrow. I'll give you an update, thx!

You should be all good after restarting Tomcat. Just re-issue that cert.

@jared_f Server is looking good! Just looking into how to reissue the cert today.

@TomDay Under Setttings > Apache Tomcat Settings > Edit > Change SSL Used for HTTPS > Generate a certificate from the Jamf Pro's built-in CA

That being said, you might not have to do that depending on the cert you are using. In my case, I generate one that is self signed.

@TomDay I did some DNS creeping lol. If it is the correct Jamf instance, your cert looks fine. Just make sure devices are checking-in and updating inventory.

Just got off the phone with jamf, had them look over my shoulder to double check. We are all good, thx for your help @jared_f !