안쓰니 자꾸 까먹네 ㅠㅠ

mysql 4.x/5.x

mysql> GRANT ALL PRIVILEGES ON dbname.* TO dbuser[@localhost] [ IDENTIFIED BY '암호'
]
mysql> FLUSH PRIVILEGES;

(user, db 테이블에 적용됨)

http://dev.mysql.com/doc/refman/6.0/en/grant.html


mysql> SHOW GRANTS FOR 'root'@'localhost';
mysql> SHOW GRANTS;

http://dev.mysql.com/doc/refman/6.0/en/show-grants.html