主机'*‘和主机'%’之间的差异

Question

当我运行以下命令时：

SELECT user, host, password, plugin FROM mysql.user WHERE user='user_123';

我得到的是：

+----------+---------------------------------------+-------------------------------------------+-----------------------+
| user     | host                                  | password                                  | plugin                |
+----------+---------------------------------------+-------------------------------------------+-----------------------+
| user_123 | IPv4-address-1                        | *775F9B443B3F45EC0042CE69872E7CF2D20D7FB4 | mysql_native_password |
| user_123 | IPv4-address-2                        | *775F9B443B3F45EC0042CE69872E7CF2D20D7FB4 | mysql_native_password |
<snip>
| user_123 | domain-1                              | *775F9B443B3F45EC0042CE69872E7CF2D20D7FB4 | mysql_native_password |
| user_123 | domain-2                              | *775F9B443B3F45EC0042CE69872E7CF2D20D7FB4 | mysql_native_password |
<snip>
| user_123 | %                                     | *775F9B443B3F45EC0042CE69872E7CF2D20D7FB4 | mysql_native_password |
| user_123 | *                                     | *775F9B443B3F45EC0042CE69872E7CF2D20D7FB4 | mysql_native_password |
+----------+---------------------------------------+-------------------------------------------+-----------------------+

我知道%代表通配符，但是%和*有什么区别呢？

Answer 1

Per 创建用户 %有通配符的意思。_还匹配单个字符，如喜欢表达式。

*没有任何意义，可能是一些不熟悉他们正在做的事情的人放在那里的。建议放弃这种使用。