-- 유저생성 후 keycloak 데이터베이스에 대한 권한 부여
select host,user from mysql.user;
create user 'ckckdm'@'%' identified by 'Enterprise Cloud2018!';
grant all privileges on keycloak.* to ckckdm@'%';
show grants for 'user'@'접속위치';
show grants;

-- keycloak, keycloak 계정
CREATE DATABASE keycloak;
USE keycloak;

-- 옛날 방식
SELECT PASSWORD('keycloak');
GRANT ALL PRIVILEGES ON *.* TO `keycloak`@`%` IDENTIFIED BY PASSWORD '' WITH GRANT OPTION;
FLUSH PRIVILEGES;

-- 개선 방식
CREATE USER IF NOT EXISTS 'keycloak'@'%' IDENTIFIED BY 'keycloak';
GRANT ALL PRIVILEGES ON *.* TO 'keycloak'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

extraEnv: |
# DB datasource information 수정