MYSQL
USER 생성
from-sh
2022. 10. 19. 10:36
728x90
SELECT * FROM MYSQL.USER;
CREATE USER 'USER_NAME'@'IP' IDENTIFIED BY "";
SHOW GRANTS FOR 'USER_NAME'@'IP';
GRANT USAGE ON *.* TO 'USER_NAME'@'IP';
GRANT SELECT ON "DATABASE_NAME".* TO 'USER_NAME'@'IP';
SHOW GRANTS FOR 'USER_NAME'@'IP';
--- 재시작 없이 변경 분 적용 쿼리 / ID, PASSWORD 추가 변경 시 필요
FLUSH PRIVILEGES;
728x90