I have 2 pods(1mysql+1idm) on Kubernetes Cluster (1 master+1 worker node on VirtualBox)
Although Keyrock creates the idm database, it cannot be migrated. So the superuser is never inserted into db and many fields of the tables are missing.
Below are presented the idm's logs from the relative container:
To find out about the concret problem with your installation, I would need more information about config and version of MySql and Keyrock.
To not have that problems, I would recommend using the keyrock helm-chart: https://github.com/FIWARE/helm-charts/tree/main/charts/keyrock
Its tested to run with the Bitnami-MySql(https://github.com/bitnami/charts/tree/master/bitnami/mysql) Chart out of the box.