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=gcdmg-mysql-2@m.gmane.org

RE: Problem with MySQL user

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:joliver@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=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e 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=3Dgcdmg-mysql-2@m.gmane.o rg