-
Notifications
You must be signed in to change notification settings - Fork 5
DB 설정 방법
JiEun Lee edited this page Nov 2, 2020
·
1 revision
create database issue_tracker_db default charset set utf8;
show databases;
-
issue_tracker_db
데이터베이스 생성 후, 확인
create user 'pastel'@'localhost' identified by 'pastel12345';
create user 'pastel'@'%' identified by 'pastel12345';
-
user
: pastel,password
: pastel12345 설정
grant all privileges on issue_tracker_db.* to 'pastel'@'localhost';
grant all privileges on issue_tracker_db.* to 'pastel'@'%';
flush privileges;
- pastel 유저에게 issue_tracker_db 권한 부여
DB_HOST=127.0.0.1
DB_USER=pastel
DB_NAME=issue_tracker_db
DB_PASS=pastel12345