Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Rene Fournier (m5renefournier.com)
Date: Tue Sep 30 2008 - 09:39:21 CDT
So with skip-name-resolve in my.cnf (and MySQL restarted), it should
be okay to have userlocalhost in the GRANT table since localhost
resolves without DNS lookup? Or do I need to specify user127.0.0.1?
Sorry, just need to clarify this bit before changing a few things.
On 24-Sep-08, at 3:33 PM, Ken Menzel wrote:
> Yes, you can still use a hostname in the connection string, that's
> not what mysql uses it for, that hostname gets you from the client
> to the server. If you use GRANT to permit access from certain hosts
> IE 'grant all on mydb.* to 'mydbuuser''%.mydomain.com'. Then the
> server will not be able to resolve those named permissions from the
> connecting IP back to a domain name matched to a grant to allow
> login. Also I don't think you can use subnets in a grant, you can
> use a single IP. However 'myuser''%' should continue to work just
> fine as should localhost using the file socket. Everything else
> should behave normally. Localhost connections are usually through
> the the mysql socket file (/tmp/mysql.sock) not 127.0.0.1 and is
> mapped to localhost.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql