summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <monty@tik.mysql.fi>2001-11-21 15:39:00 +0200
committerunknown <monty@tik.mysql.fi>2001-11-21 15:39:00 +0200
commitaf4f887129e009ba7c097a4b03db92ef1acbc25e (patch)
tree7a5c33507472e785c574a031b3bedd9163de03af
parentc9e2debfe3dab612234d2ae76c182efe6a78268a (diff)
downloadmariadb-git-af4f887129e009ba7c097a4b03db92ef1acbc25e.tar.gz
Added note to manual that usernames in GRANT don't allow wildcards.
Docs/manual.texi: Added note that usernames in GRANT don't allow wildcards.
-rw-r--r--Docs/manual.texi19
1 files changed, 12 insertions, 7 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 5356e8f4dfe..07259633a89 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -15941,14 +15941,19 @@ You can specify wild cards in the hostname. For example,
for any host in the @code{144.155.166} class C subnet.
The simple form @code{user} is a synonym for @code{user@@"%"}.
+
+MySQL doesn't support wildcards in user names. Anonymous users are
+defined by inserting entries with @code{User=''} into the
+@code{mysql.user} table or creating an user with an empty name with the
+@code{GRANT} command.
+
@strong{Note:} If you allow anonymous users to connect to the MySQL
-server (which is the default), you should also add all local users as
-@code{user@@localhost} because otherwise the anonymous user entry for the
-local host in the @code{mysql.user} table will be used when the user tries to
-log into the MySQL server from the local machine! Anonymous users
-are defined by inserting entries with @code{User=''} into the
-@code{mysql.user} table. You can verify if this applies to you by executing
-this query:
+server, you should also grant privileges to all local users as
+@code{user@@localhost} because otherwise the anonymous user entry for
+the local host in the @code{mysql.user} table will be used when the user
+tries to log into the MySQL server from the local machine!
+
+You can verify if this applies to you by executing this query:
@example
mysql> SELECT Host,User FROM mysql.user WHERE User='';