Error on MySQL configuration

Configuring the server
1

Ok, well I’m having trouble with getting keycloak running on MySQL. I’ve worked through all the documentation on doing it, but still no joy. The error comes when initializing the database:

17:10:36,106 ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 62) Change Set META-INF/jpa-changelog-2.5.0.xml::2.5.0-unicode-other-dbs::hmlnarik@redhat.com failed.  Error: Specified key was too long; max key length is 1000 bytes [Failed SQL: ALTER TABLE davidgs_keycloak.USER_ENTITY ADD CONSTRAINT UK_RU8TT6T700S9V50BU18WS5HA6 UNIQUE (REALM_ID, USERNAME)]
17:10:36,107 ERROR [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 62) Error has occurred while updating the database: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-2.5.0.xml::2.5.0-unicode-other-dbs::hmlnarik@redhat.com:
     Reason: liquibase.exception.DatabaseException: Specified key was too long; max key length is 1000 bytes [Failed SQL: ALTER TABLE davidgs_keycloak.USER_ENTITY ADD CONSTRAINT UK_RU8TT6T700S9V50BU18WS5HA6 UNIQUE (REALM_ID, USERNAME)]

Any idea what I’m doing wrong here? I’m sure it’s something super simple and I’ve just been staring at it too long but I’m stumped! (I’m having trouble with SSL configuration as well, but that will come up later :slight_smile: )

Thanks!
dg