Oracle/Mysql/Sql

Mysql User 추가

gilnet 2013. 4. 9. 17:21

mysql -u root -p

패스워드 입력 후 

GRANT ALL PRIVILEGES ON *.* TO 'id'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'id'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

flush privileges;

형식으로 유저 추가