List:General Discussion« Previous MessageNext Message »
From:burhan.khalid Date:July 5 2010 6:17pm
Subject:Re: Why is Host option Failing?
View as plain text  
Michael:

  It could be that MySQL is only listening on localhost (127.0.0.1) and not your net IP. Check your network settings in your server config. Alternately, you can also do a 

netstat -anp | grep mysql

As root and see where it is listening.

Regards,
--
Burhan Khalid
Sent from my BlackBerry® smartphone from Wataniya Telecom

-----Original Message-----
From: Michael Satterwhite <michael@stripped>
Date: Mon, 5 Jul 2010 10:04:22 
To: Martin Clarke<clarkem7@stripped>
Cc: <mysql@lists.mysql.com>
Subject: Re: Why is Host option Failing?

On Monday, July 05, 2010 08:26:03 am you wrote:
> Hi,
> 
> dig should be in /usr/bin but its possible it isn't installed
> I'm not sure about PcLinuxOS but it's in the dnsutils package on
> debian/Ubuntu.

As you said earlier, it's not necessary to use dig to check the ip address. 
Ping does the job. 
> 
> Also, after you change DB/User permissions with GRANT statements it's often
> necessary to do a 'FLUSH PRIVILEGES;'
This I didn't know.. I just tried it, though, and it makes no difference.

> 
> It's also entirely possible that Photon resolves to 127.0.0.1 in which case
> you will need  GRANT for 'michael'@'localhost'
> Is the name pho

[michael@photon ~]$ ping photon
PING photon (192.168.1.20) 56(84) bytes of data.
64 bytes from photon (192.168.1.20): icmp_seq=1 ttl=64 time=0.047 ms
64 bytes from photon (192.168.1.20): icmp_seq=2 ttl=64 time=0.045 ms


> ton listed in /etc/hosts ?
> 
> Hope thats of some use
> mc
> 
> On 5 July 2010 03:35, Michael Satterwhite <michael@weblore.com> wrote:
> > On Sunday, July 04, 2010 06:36:00 pm you wrote:
> > > What user are you at the time you are running these tests.  Would I be
> > > correct in guessing 'root'?
> > > 
> > > The reason localhost works is because, in some distros, root is
> > > enabled localhost with no password .. which is dangerous enough..
> > > granting root@'%" would be an invitation to disaster..
> > > 
> > > From that same command line, what do you get for
> > > $ dig photon
> > > 
> > > You likely want to make a grant suitable rfor that network address for
> > > the user you are trying to use.
> > > 
> > >  - michael dykman
> > 
> > This sounded good, but....
> > 
> > "dig photon" returns "command not found"
> > 
> > I logged onto the server as root and issued the command:
> > 
> > grant all privileges on *.* to 'michael'@'%' identified by ????;
> > (??? is the password, in quotes, of course). It responded
> > 
> >        Query OK, 0 rows affected (0.00 sec)
> > 
> > I still can't connect via
> > 
> >        mysql -h photon -u michael -p??????
> > 

> > Still
> > 
> >         ERROR 2003 (HY000): Can't connect to MySQL server on 'photon'
> >         (111)
> > 
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1om

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=burhan.khalid@stripped

Thread
Why is Host option Failing?Michael Satterwhite5 Jul
  • Re: Why is Host option Failing?Michael Dykman5 Jul
Re: Why is Host option Failing?Michael Satterwhite5 Jul
Re: Why is Host option Failing?Michael Satterwhite5 Jul
  • Re: Why is Host option Failing?Bob Cole5 Jul
    • Re: Why is Host option Failing?Michael Satterwhite5 Jul
  • Re: Why is Host option Failing?burhan.khalid5 Jul