On Fri, 6 Feb 2004, Alvaro Avello wrote: > the questions is , the wildcard in host field doesn't > involve localhost o a machine host's ? Which kind of permissions we > have to put in host fields to have a mobility and not to be afraid to > move our servers for an emergency ?
When the host field is localhost, it is checked against when connecting through a local socket, when not it's checked when connecting through TCP/IP. You can force a TCP/IP socket over a Unix socket when connecting from the local computer by instead of connecting to localhost in your application connect to 127.0.0.1 or the computer's IP. This however will slightly decrease performance, since a Unix socket is faster. A fix if you have to emergency move the server could be to just change the fields from localhost to '%'. cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]