MySQL权限管理部分------授予用户权限

最新推荐文章于 2024-08-12 14:54:22 发布

jiav_net

最新推荐文章于 2024-08-12 14:54:22 发布

阅读量124

点赞数

文章标签：数据库

本文介绍了MySQL如何通过指定user_name@host_name的形式来设置用户的访问权限，包括如何使用通配符来定义host_name，并解释了当username或hostname包含特殊字符时应该如何进行引用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 @'%'效果相同。