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 <mich...@weblore.com> Date: Mon, 5 Jul 2010 10:04:22 To: Martin Clarke<clark...@gmail.com> 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 [mich...@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 <mich...@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=clark...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=burhan.kha...@gmail.com