Am 05.05.2014 11:12, schrieb Jigal van Hemert: > On 5-5-2014 10:57, Reindl Harald wrote: >> >> >> Am 05.05.2014 10:19, schrieb Manuel Arostegui: >>> 2014-05-05 10:00 GMT+02:00 Reindl Harald <h.rei...@thelounge.net >>> <mailto:h.rei...@thelounge.net>>: >>> >>> Am 05.05.2014 08:34, schrieb Manuel Arostegui: >>> > "%" doesn't match localhost so if you don't specify it you will be >>> > attempting to connect via Unix Socket. >>> > If you don't want to specify -hlocalhost all the time, just do the >>> grant >>> > with "@localhost" instead of "@%" >>> >>> nonsense >>> >>> % matches *any host* >>> >>> Do the test yourself >> >> i don't need to test such basics since i am working >> as mysql administrator the last 11 years and curently >> responsible for some hundret databases heavily using >> host specific permissions >> >> http://dev.mysql.com/doc/refman/5.5/en/connection-access.html >> '%' 'fred' fred, connecting from any host > > In that case you would know that connecting via a Unix socket is not the same > as connection via a network. > > See: > http://bugs.mysql.com/bug.php?id=69570 > http://dev.mysql.com/doc/refman/5.5/en/connecting.html
i know that, but it does not change the fact that here are mysql users in production which are using % and accessed via localhost unix-socket as well as via TCP from remote-machines with mysql-over-ssl maybe MariaDB don't have that bug and it is a bug if you can't connect with a user specified with % over the unix-socket independent what some guy from Oracle pretends
signature.asc
Description: OpenPGP digital signature
