Keycloak SSO minimum mysql database privileges

Question

I have been trying to install Keycloak but instead of the usual 'GRANT ALL PRIVILEGES' command to grant access to the database to the MySQL database, I need the exact minimum privileges to be granted. I have been looking at Keycloak documentation for this but I did not find any.

Thanks.

score 1 · Accepted Answer · answered Oct 22 '19 at 05:50

1

For those wondering, the following privileges work:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, REFERENCES, INDEX, DROP ON `<database>`.* TO `<user>`@`<host>`;

answered Oct 22 '19 at 05:50

Lester

597
4
16

Keycloak SSO minimum mysql database privileges

1 Answers1