링크
유용한 명령어
mysqladmin -u root -p create wsportal GRANT ALL ON *.* TO wsportal@localhost IDENTIFIED BY 'wsportal' WITH GRANT OPTION; GRANT SELECT ON wsportal.* TO wsportal@'%' IDENTIFIED BY 'wsportal'; C:mysqlbin> mysqldump -a db_name > C:/file.sql
13.5.1.2 GRANT and REVOKE Syntax
GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY [PASSWORD] 'password']] ...
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER cipher [AND]]
[ISSUER issuer [AND]]
[SUBJECT subject]]
[WITH [GRANT OPTION | MAX_QUERIES_PER_HOUR # |
MAX_UPDATES_PER_HOUR # |
MAX_CONNECTIONS_PER_HOUR #]]
REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ...
ON {tbl_name | * | *.* | db_name.*}
FROM user_name [, user_name] ...
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_name [, user_name] ...GRANT와 REVOKE는 MySQL 3.22.11 이후 버전에서 구현되었다. 그 이전 버전에서, 이런 문장들은 동작하지 않는다.