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;
형식으로 유저 추가