MySQL Account Name

最新推荐文章于 2022-11-26 17:59:57 发布

weixin_34008805

最新推荐文章于 2022-11-26 17:59:57 发布

阅读量142

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/xinxingegeya/blog/271277

版权

2019独角兽企业重金招聘Python工程师标准>>>

MySQL Account Name

mysql5.6参考手册中如下解释：

MySQL account names consist of a user name and a host name. This enables creation of accounts for users with the same name who can connect from different hosts.

也就是说mysql的账号由一个用户名和主机名来组成，用来区分不同主机上的相同用户名。

write account names using the following rules:

Syntax for account names is 'user_name'@'host_name'.

An account name consisting only of a user name is equivalent to 'user_name'@'%'. For example, 'me' is equivalent to 'me'@'%'.

The user name and host name need not be quoted(引用) if they are legal(合法) as unquoted identifiers. 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'@'%.com'.

Quote user names and host names as identifiers or as strings, using either backticks (“`”), single quotation marks (“'”), or double quotation marks (“"”).(使用单引号或双引号)

The user name and host name parts, if quoted, must be quoted separately. That is, write 'me'@'localhost', not'me@localhost '; the latter is interpreted as 'me@localhost '@'%'.

A reference to the CURRENT_USER or CURRENT_USER() function is equivalent to specifying the current client's user name and host name literally.