Skip to content

Latest commit

 

History

History
40 lines (30 loc) · 979 Bytes

SCRIPTS.md

File metadata and controls

40 lines (30 loc) · 979 Bytes
Raw

Useful Scripts

k8s

connect to k8s mysql service

kubectl port-forward service/ccds-test-mysql 33306:3306

docker

docker run --name mariadbtest -e MYSQL_ROOT_PASSWORD=mypass -p 33306:3306 -d docker.io/library/mariadb:10.8
docker exec -i mariadbtest mysql -uroot -pmypass -e "
  CREATE DATABASE IF NOT EXISTS cds_admin; 
  CREATE USER IF NOT EXISTS 'cds_admin'@'%' IDENTIFIED BY 'cds_admin';
  GRANT ALL PRIVILEGES ON *.* TO 'cds_admin'@'%' WITH GRANT OPTION;
"

Env File

CDS_REQUIRES_DB_CREDENTIALS_USER=cds_admin
CDS_REQUIRES_DB_CREDENTIALS_PASSWORD=cds_admin
CDS_REQUIRES_DB_CREDENTIALS_DATABASE=cds_admin
CDS_REQUIRES_DB_CREDENTIALS_HOST=127.0.0.1
CDS_REQUIRES_DB_CREDENTIALS_PORT=33306

User Creation

create user for multitenancy

CREATE DATABASE IF NOT EXISTS `cds_admin`;
CREATE USER IF NOT EXISTS 'cds_admin'@'%' IDENTIFIED BY 'cds_admin';
GRANT ALL PRIVILEGES ON *.* TO 'cds_admin'@'%' WITH GRANT OPTION;