HELP! Error while trying to create admin user

Hello, I am getting an error after i pressed finish set up on the admin creation screen.

I am not sure if the error is caused by my configuration of the storage and database to my “mysql database”.

Error while trying to create admin user: An exception occurred while executing ‘CREATE TABLE oc_migrations (app VARCHAR(255) NOT NULL, version VARCHAR(255) NOT NULL, PRIMARY KEY(app, version)) DEFAULT CHARACTER SET UTF8 COLLATE utf8_bin ENGINE = InnoDB’: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

Thank You Very Much.

did you look at this?

https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/linux_database_configuration.html