I am running mySQL version mysql Ver 8.0.22-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)) with the latest CC3 and Spigot 1.16.3.

I have a bungeecord setup and I'm trying to sync CC3 across servers using a mysql database. I used /ccsetup database and followed all steps. The database is set up correctly and credentials are right, I'm able to access it from mysql CLI and I can see entries for CC3, but unfortunately I can't do anything in game as I get the error [02:18:43] [Server thread/INFO]: [Money] This command is disabled while Craftconomy is under setup mode! Type /ccsetup to configure the plugin.

This (hastebin) is the error I get right after completing configuration with /ccsetup. There seems to be a warning about SSL and then something about a bad primary key:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

What can I do to get it working? Is there something I should change on the mysql side of things or is it a cc3 issue?