LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 09-16-2009, 06:00 PM   #1
jnojr
Member
 
Registered: Sep 2007
Location: San Diego, CA
Posts: 223

Rep: Reputation: 20
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.
 
Old 09-16-2009, 08:22 PM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 7.7 (?), Centos 8.1
Posts: 17,873

Rep: Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600Reputation: 2600
You did specify 'user'@'172.16.1.2' as the enabled user; is the 'client' box that exact IP? ie not just in '172.16.1.X', unless you change it to be a wildcard; see the mysql docs http://dev.mysql.com/doc/refman/5.0/en/
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[phpMYAdmin] Problem ! Help. I''ve deleted root user in MYSQL combilli Linux - Software 1 12-07-2006 01:30 PM
MySQL 4.1 user/password problem devfreak Linux - Software 4 03-23-2006 01:54 PM
How can a non-mythtv user open mythfrontend in ubuntu? Could it by a MySQL problem? LiquidSlumber Ubuntu 0 03-19-2006 02:01 AM
MySQL problem with user privileges jriis Linux - Software 3 10-02-2003 09:20 AM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 02:24 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:36 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration