Hi John, You can turn of name resolution by adding skip-name-resolve to the [mysqld] section of your my.cnf file.
Regards, Gavin Towey -----Original Message----- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Wednesday, September 16, 2009 4:24 PM To: mysql@lists.mysql.com Subject: Problem with MySQL user I'm working with two VMs, one a web server, one a MySQL database server. In mysql, I added a 'user'@'172.16.1.2' with privileges appropriate for the web site, and that works. The VMs got shipped off to a hosting facility. They got the 172.16.1.X network between the two VMs up, but when they try to "mysql -h 172.16.1.1 -uuser -p" and enter the password, they get an error denying 'user'@'hostname' Why is MySQL resolving the IPs? I figured it would be quicker to fix that than it would be to look up the specific privileges for that user, add 'user'@'hostname', and then go in and start modifying the config (it's set in settings.php as well as several places in the httpd.conf) I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2 to known hostnames. -- *********************************************************************** * John Oliver http://www.john-oliver.net/ * * * *********************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
