Database/SQL

[MySQL] 유저 생성

lumination 2025. 6. 30. 09:02
# 유저 생성
CREATE USER 'devuser'@'localhost' IDENTIFIED BY 'StrongPass123!';

# dev_db 권한 부여
GRANT ALL PRIVILEGES ON dev_db.* TO 'devuser'@'localhost';

# 변경 사항 적용
FLUSH PRIVILEGES;

---
# localhost
CREATE USER 'board'@'localhost' IDENTIFIED BY 'board.123';
GRANT ALL PRIVILEGES ON *.* TO 'board'@'localhost';

# all host
CREATE USER 'board'@'%' IDENTIFIED BY 'board.123';
GRANT ALL PRIVILEGES ON *.* TO 'board'@'%';