[MySQL] 사용자 추가/권한주기

(2005/12/27 09:49 작성)

출처 : http://www.dev.mysql.com 

 

mysql> GRANT ALL PRIVILEGES ON *.* TO 'USER_ID'@'localhost'
    ->     IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'USER_ID'@'%'
    ->     IDENTIFIED BY 'PASSWORD';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';