Wild-card user-unfriendly feature

Hello, MySQL developers

By default, MySQL installs a wild-card user that can connect from localhost
and from the hostname of the server to the test database. This causes a
problem with wild-card hosts. When a wild-card host user connects locally (
from localhost or the server hostname), the default blank user entry in the
priv tables happens to be more specific in the opinon of the entry matching
algorithm than the newly created wild-card entry, and causes an Access Denied
error. To fix the problem, one would need to delete the default blank user
entries. While the behavior is documented in the manual, the combination of
default entries and the matching algorithm turns out to be very much
user-unfriendly.

--
Sasha Pachev
Create online surveys at http://www.surveypro.com/

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Wild-card user-unfriendly feature

Sasha Pachev writes:
> Hello, MySQL developers
>
> By default, MySQL installs a wild-card user that can connect from localhost
> and from the hostname of the server to the test database. This causes a
> problem with wild-card hosts. When a wild-card host user connects locally (
> from localhost or the server hostname), the default blank user entry in the
> priv tables happens to be more specific in the opinon of the entry matching
> algorithm than the newly created wild-card entry, and causes an Access Denied
> error. To fix the problem, one would need to delete the default blank user
> entries. While the behavior is documented in the manual, the combination of
> default entries and the matching algorithm turns out to be very much
> user-unfriendly.
>
> --
> Sasha Pachev
> Create online surveys at http://www.surveypro.com/


Yes, we are aware of the above.

However, on many installations, anonymous users , id est those with
empty user name, have found some use.

As a workaround, always specify user, either in argument or in .my.cnf
file.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org