mysql的賬戶AccountNameusername和hostname_MySQL

來源：懂視網責編：小采時間：2020-11-09 19:23:58

mysql的賬戶AccountNameusername和hostname_MySQL

mysql的賬戶AccountNameusername和hostname_MySQL: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 c

推薦度：

點擊下載本文 文檔為doc格式

導讀mysql的賬戶AccountNameusername和hostname_MySQL: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 c

也就是說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.

詳見：http://dev.mysql.com/doc/refman/5.6/en/account-names.html

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com