keycloak-configure-mysql-database

keycloak-configure-mysql-database

https://www.appsdeveloperblog.com/keycloak-configure-mysql-database/

SHOW VARIABLES LIKE 'validate_password%';
SET GLOBAL validate_password.policy=LOW;
SET GLOBAL validate_password.length=6;


crear usuario
CREATE USER 'dbadmin'@'%' IDENTIFIED BY 'qwe123';

SHOW DATABASES;
CREATE DATABASE db_liquor;

Permisos
GRANT ALL ON magento_remote.* TO dbadmin@192.168.242.160 IDENTIFIED BY 'qwe123';
GRANT ALL PRIVILEGES ON * . * TO 'dbadmin'@'192.168.242.160';

GRANT ALL ON db_liquor.* TO 'dbadmin'@'192.168.242.160' WITH GRANT OPTION;




mysql> CREATE DATABASE keycloak CHARACTER SET utf8 COLLATE utf8_unicode_ci;

mysql> CREATE USER 'keycloak-user'@'%' IDENTIFIED BY '1h7rHhfy3';

mysql> GRANT ALL PRIVILEGES ON keycloak.* TO 'keycloak-user'@'%';

mysql> flush privileges;



<?xml version="1.0" ?>
<module xmlns="urn:jboss:module:1.3" name="com.mysql">
 <resources>
  <resource-root path="mysql-connector-java-8.0.20.jar" />
 </resources>
 <dependencies>
  <module name="javax.api"/>
  <module name="javax.transaction.api"/>
 </dependencies>
</module>