blocks|key|342458|text|localhost在MySQL中是特殊的，它意味着通过UNIX套接字(我相信在Windows上是命名管道)而不是TCP/IP套接字的连接。使用%25作为主机不包括localhost，因此需要显式指定它。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|342459|entityMap^0|0|9|1Z|1|27|9|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

<code>localhost</code> is special in MySQL, it means a connection over a UNIX socket (or named pipes on Windows, I believe) as opposed to a TCP/IP socket. Using <code>%</code> as the host does not include <code>localhost</code>, hence the need to explicitly specify it.

blocks|key|558519|text|如果要从本地主机连接到user@'%25'，请使用mysql+-h192.168.0.1+-uuser+-p。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|558520|entityMap^0|B|8|N|T|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

If you want connect to <code>user@'%'</code> from localhost use <code>mysql -h192.168.0.1 -uuser -p</code>.

blocks|key|558601|text|正如@nos在对这个问题的当前接受答案的评论中指出的那样，接受的答案是不正确的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|558602|是的，当通过套接字连接而不是标准的%25+/IP连接进行连接时，对用户帐户主机使用localhost和TCP是有区别的。|offset|length|style|CODE|558603|主机值%25不包括套接字的localhost，因此如果要使用该方法进行连接，则必须指定该值。|558604|entityMap^0|0|H|1|13|9|0|3|1|B|9|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|K|$]]

As @nos pointed out in the comments of the currently accepted answer to this question, the accepted answer is incorrect.

Yes, there IS a difference between using <code>%</code> and <code>localhost</code> for the user account host when connecting via a socket connect instead of a standard TCP/IP connect.

A host value of <code>%</code> does not include <code>localhost</code> for sockets and thus must be specified if you want to connect using that method.

blocks|key|558654|text|将提供与到目前为止提供的答案略有不同的答案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|558655|如果在users表''@'localhost'中有一行来自本地主机的匿名用户，那么这将被视为比带有通配符的主机'user'@'%25'的用户更具体。这就是为什么还需要提供'user'@'localhost'的原因。|offset|length|style|CODE|558656|您可以在this+page的底部看到更详细的解释。|558657|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.5/en/connection-access.html^0|0|9|E|1J|A|2B|I|0|4|9|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]|$D|X|E|Y|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|J|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

Going to provide a slightly different answer to those provided so far.

If you have a row for an anonymous user from localhost in your users table <code>''@'localhost'</code> then this will be treated as more specific than your user with wildcard'd host <code>'user'@'%'</code>. This is why it is necessary to also provide <code>'user'@'localhost'</code>.

You can see this explained in more detail at the bottom of <a href="http://dev.mysql.com/doc/refman/5.5/en/connection-access.html" rel="noreferrer">this page</a>.

My MySQL database needs two users: appuser and support. 
One of the application developers insists that I create four accounts for these users:

<pre><code>appuser@'%'
appuser@'localhost'
support@'%'
support@'localhost'
</code></pre>

For the life of me I can't figure out why he thinks we need this. Wouldn't using the wildcard as the host take care of the 'localhost'?

Any ideas?

(Using MySQL 5.5 here)

Using % for host when creating a MySQL user

SQL数据库

数据库

Windows

MySQL

我的MySQL数据库需要两个用户: appuser和support。其中一个应用程序开发人员坚持要我为这些用户创建四个帐户：appuser@'%'appuser@'localhost'support@'%'support@'localhost'我真搞不懂他为什么认为我们需要这个。不是使用通配符作为主机来处理“local...

问创建MySQL用户时使用%作为主机
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问创建MySQL用户时使用%作为主机EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问创建MySQL用户时使用%作为主机
EN