On 10 Jan 2004, at 17:47, Michael Stassen wrote:
Eg. if you've two host entries; one '192.%' and the other '192.168.%' - and you connect from 192.168.100.12, which row gets chosen?
As I understand it, 192.168.% is more specific than 192.%, so 192.168.100.12 would match 192.168.%
My thoughts exactly.
But what if there isn't a more exact match... i.e. choose between '192.%' or '%.168.%'
Well, I can't imagine why you would put %.168.% in for host. If you did, I think 192.% would be more specific than %.168.%, but the manual is unclear on that. I suppose you could try it and see.
True, I can't imagine why you would want to use %.168.% either; I was just curious.
I've just tried it myself... (OK, so I was lazy before! :) - MySQL appears to prefer 192.% over %.168.%
What if there are two entries - 'localhost' and '127.0.0.1' ?
To mysql, those are not the same. localhost is a unix socket connection, 127.0.0.1 is a TCP/IP connection. So,
mysql -u username -p
would connect as [EMAIL PROTECTED], but
mysql -h 127.0.0.1 -u username -p
would connect as [EMAIL PROTECTED]
Makes sense.
Thanks very much; I was just curious!
Steve.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]