Develop/MySQL
[MySQL] Create DB & Grant
시크라기
2012. 4. 27. 10:21
CREATE DATABASE [IF NOT EXISTS] [db_name]
GRANT ALL PRIVILEGES ON [db_name].* TO [user_Id]@localhost IDENTIFIED BY '[password]'
PS) 계정 추가
GRANT USAGE ON *.* TO [user_id]@localhost IDENTIFIED BY "[password]";