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
