16 lines
518 B
MySQL
16 lines
518 B
MySQL
|
-- 종량제 로컬 개발 DB 초기화
|
||
|
|
-- 실행: mariadb -u root < writable/database/init_jongryangje_dev.sql
|
||
|
|
-- 또는: mysql -u root < writable/database/init_jongryangje_dev.sql
|
||
|
|
|
||
|
|
CREATE DATABASE IF NOT EXISTS jongryangje_dev
|
||
|
|
CHARACTER SET utf8mb4
|
||
|
|
COLLATE utf8mb4_unicode_ci;
|
||
|
|
|
||
|
|
CREATE USER IF NOT EXISTS 'jongryangje'@'localhost'
|
||
|
|
IDENTIFIED BY 'jongryangje_dev';
|
||
|
|
|
||
|
|
GRANT ALL PRIVILEGES ON jongryangje_dev.* TO 'jongryangje'@'localhost';
|
||
|
|
FLUSH PRIVILEGES;
|
||
|
|
|
||
|
|
SELECT 'jongryangje_dev DB and user ready.' AS result;
|