[MySQL] 기본 설정 팁 1
2019. 10. 17. 16:01
사용자 추가 - CREATE USER 'userId'@'allow address' IDENTIFIED BY 'password'; ex ) CREATE USER 'bluewhale'@'localhost' IDENTIFIED BY '1234'; CREATE USER 'bluewhale'@'%' IDENTIFIED BY '12345'; CREATE USER 'bluewhale'@'123.123.123.123' IDENTIFIED BY '2345'; 사용자 삭제 - DROP USER 'userid'@'allow address'; ex ) DROP USER 'bluewhale'@'localhost'; DROP USER 'bluewhale'@'%'; DB 생성 - CREATE DATABASE dbname; ex )..