Sinisa Milivojevic writes:
> > We found that, if you alter the permission tables (user) & /etc/hosts > > (so that it can do IP-address-to-hostname mapping for the hosts named in > > "user") & say "mysqladmin reload", mysql doesn't pick up the changes - > > you have to shut it down totally & restart it. > > mysqladmin reload only reloads info from MySQL privilege tables. Does this mean that mysqld keeps its own cache of hostnames, and that it never checks to see if it has gone stale? If so, one might have to shut down and restart the server at regular intervals (once an hour or whatever) if one relies on host names (maybe not a good idea unless you can control the DNS server and/or hosts file) for additional security. This, of course, assuming that the name<->address mapping isn't absolutely constant, but it rarely is. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
