Results 1 to 2 of 2
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. ...
- 09-16-2009 #1Linux Newbie
- Join Date
- Sep 2007
- Posts
- 105
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.
- 09-21-2009 #2Linux Guru
- Join Date
- Apr 2009
- Location
- I can be found either 40 miles west of Chicago, or in a galaxy far, far away.
- Posts
- 8,974
I think MySql uses the system password subsystem to validate users. Does the specified user exist on the 172.16.1.2 VM host? Is the password for the user correct?
Sometimes, real fast is almost as good as real time.
Just remember, Semper Gumbi - always be flexible!
Reply With Quote 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts