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]";