Build Your Own DatabaseDriven Website Using PHP amp;amp; MySQL [Electronic resources]

Kevin Yank

نسخه متنی -صفحه : 190/ 107
نمايش فراداده

GRANT

GRANT priv_type [(column_list)], ...
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY 'password'], ...
[WITH GRANT OPTION]

GRANT adds new access privileges to a user account, and creates a new account if the specified user_name does not yet exist, or changes the password if IDENTIFIED BY 'password' is used on an account that already has a password.

See "MySQL Access Control" for a complete description of this query.