MySQL権限管理部------ユーザー権限付与
1418 ワード
To accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the
user
value in the form user_name
@ host_name
. If a user_name
or host_name
value is legal as an unquoted identifier, you need not quote it. However, quotes are necessary to specify a user_name
string containing special characters (such as “-
”), or a host_name
string containing special characters or wildcard characters (such as “%
”); for example, 'test-user'@'test-hostname'
. Quote the username and hostname separately.
You can specify wildcards in the hostname. For example, user_name
@'%.loc.gov' applies to user_name
for any host in the loc.gov
user_name
@'144.155.166.%' applies to user_name
for any host in the 144.155.166
class C subnet. domain, and
The simple form user_name
is a synonym for user_name
@'%' .
user_nameはuser_name
@'%'と じ です.