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'@'%';