github.com/oinume/lekcije@v0.0.0-20231017100347-5b4c5eb6ab24/backend/db/docker-entrypoint-initdb.d/create_database.sql (about)

     1  CREATE USER IF NOT EXISTS 'lekcije'@'localhost' identified by 'lekcije';
     2  CREATE USER IF NOT EXISTS 'lekcije'@'%' identified by 'lekcije';
     3  
     4  CREATE DATABASE IF NOT EXISTS lekcije DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_bin;
     5  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON lekcije.* TO 'lekcije'@'localhost';
     6  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON lekcije.* TO 'lekcije'@'%';
     7  
     8  CREATE DATABASE IF NOT EXISTS lekcije_test DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_bin;
     9  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON lekcije_test.* TO 'lekcije'@'localhost';
    10  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES ON lekcije_test.* TO 'lekcije'@'%';
    11  
    12  FLUSH PRIVILEGES;