BillTrax/mysql-init.sql at develop · AgoraDMV/BillTrax

11 lines (9 loc) · 578 Bytes

-- Runs once when MySQL container is first initialised.
-- Creates app database + test database, grants the app user access to both.

CREATE DATABASE IF NOT EXISTS billtrax CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS billtrax_test CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- The MYSQL_USER created by the official image only gets access to MYSQL_DATABASE.
-- Grant it access to the test database too.
GRANT ALL PRIVILEGES ON billtrax.* TO 'billtrax'@'%';
GRANT ALL PRIVILEGES ON billtrax_test.* TO 'billtrax'@'%';
FLUSH PRIVILEGES;

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Expand file tree

Search code, repositories, users, issues, pull requests...

Uh oh!

FilesExpand file tree

mysql-init.sql

Latest commit

History

mysql-init.sql

File metadata and controls

Expand file tree