Why is Host option Failing?

am 05.07.2010 00:38:29 von Michael Satterwhite

I've recently reloaded my box (PCLinuxOS). The machine name on the network is
photon. I've set this in the hosts table, in hostname, and on the network. in
my.cnf I have the following 2 lines:

bind-address = photon
bind-address = localhost

The "skip-networking" directive is commented out. If I execute

mysql -h photon

I get: ERROR 2003 (HY000): Can't connect to MySQL server on 'photon' (111).

mysql -h localhost

Works fine. Would someone be so kind as to let me know what I'm missing?
Thanks in advance
---Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Why is Host option Failing?

am 05.07.2010 01:36:00 von Michael Dykman

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

On Sun, Jul 4, 2010 at 6:38 PM, Michael Satterwhite w=
rote:
> I've recently reloaded my box (PCLinuxOS). The machine name on the networ=
k is
> photon. I've set this in the hosts table, in hostname, and on the network=
.. in
> my.cnf I have the following 2 lines:
>
> bind-address =A0 =A0 =A0 =A0 =A0 = photon
> bind-address =A0 =A0 =A0 =A0 =A0 = localhost
>
> The "skip-networking" directive is commented out. If I execute
>
> =A0 =A0 =A0 =A0mysql -h photon
>
> I get: ERROR 2003 (HY000): Can't connect to MySQL server on 'photon' (111=
).
>
> mysql -h localhost
>
> Works fine. Would someone be so kind as to let me know what I'm missing?
> Thanks in advance
> ---Michael
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>

--=20
- michael dykman
- mdykman@gmail.com

May the Source be with you.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Why is Host option Failing?

am 05.07.2010 04:35:55 von Michael Satterwhite

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=gcdmg-mysql-2@m.gmane.org

Re: Why is Host option Failing?

am 05.07.2010 17:04:22 von Michael Satterwhite

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 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=clarkem7@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Why is Host option Failing?

am 05.07.2010 17:46:48 von Bob Cole

--Apple-Mail-1--610101718
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

On Jul 5, 2010, at 10:04 AM, Michael Satterwhite wrote:
>> [...snip...]
>> On 5 July 2010 03:35, Michael Satterwhite =
wrote:
>>> On Sunday, July 04, 2010 06:36:00 pm you wrote:
>>> [...snip...]
>>> I still can't connect via
>>> mysql -h photon -u michael -p??????

On my home computer I entered the following
(note there is no space between the -p and the password):
$ mysql -h www.my_abc_xyz.com -u myUserNm -pMyPasswrd

The remote computer let me into mysql and I typed:
mysql> use mysql
mysql> select host, user, Password, Select_priv from user;
=
+------------------+----------+----------------------------- --------------=
+-------------+
| host | user | Password =
| Select_priv |
=
+------------------+----------+----------------------------- --------------=
+-------------+
| localhost | myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ =
| Y |
| % | myUserNm | *ABC8C800D9A264876A32F5175DE21C1A0B89XYZ =
| Y |
=
+------------------+----------+----------------------------- --------------=
+-------------+

Your results should be similar.
HTH,
Bob

--Apple-Mail-1--610101718--

Re: Why is Host option Failing?

am 05.07.2010 18:10:21 von Michael Satterwhite

Re: Why is Host option Failing?

am 05.07.2010 20:17:57 von burhan.khalid

TWljaGFlbDoNCg0KICBJdCBjb3VsZCBiZSB0aGF0IE15U1FMIGlzIG9ubHkg bGlzdGVuaW5nIG9u
IGxvY2FsaG9zdCAoMTI3LjAuMC4xKSBhbmQgbm90IHlvdXIgbmV0IElQLiBD aGVjayB5b3VyIG5l
dHdvcmsgc2V0dGluZ3MgaW4geW91ciBzZXJ2ZXIgY29uZmlnLiBBbHRlcm5h dGVseSwgeW91IGNh
biBhbHNvIGRvIGEgDQoNCm5ldHN0YXQgLWFucCB8IGdyZXAgbXlzcWwNCg0K QXMgcm9vdCBhbmQg
c2VlIHdoZXJlIGl0IGlzIGxpc3RlbmluZy4NCg0KUmVnYXJkcywNCi0tDQpC dXJoYW4gS2hhbGlk
DQpTZW50IGZyb20gbXkgQmxhY2tCZXJyecKuIHNtYXJ0cGhvbmUgZnJvbSBX YXRhbml5YSBUZWxl
Y29tDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBNaWNo YWVsIFNhdHRlcndo
aXRlIDxtaWNoYWVsQHdlYmxvcmUuY29tPg0KRGF0ZTogTW9uLCA1IEp1bCAy MDEwIDEwOjA0OjIy
IA0KVG86IE1hcnRpbiBDbGFya2U8Y2xhcmtlbTdAZ21haWwuY29tPg0KQ2M6 IDxteXNxbEBsaXN0
cy5teXNxbC5jb20+DQpTdWJqZWN0OiBSZTogV2h5IGlzIEhvc3Qgb3B0aW9u IEZhaWxpbmc/DQoN
Ck9uIE1vbmRheSwgSnVseSAwNSwgMjAxMCAwODoyNjowMyBhbSB5b3Ugd3Jv dGU6DQo+IEhpLA0K
PiANCj4gZGlnIHNob3VsZCBiZSBpbiAvdXNyL2JpbiBidXQgaXRzIHBvc3Np YmxlIGl0IGlzbid0
IGluc3RhbGxlZA0KPiBJJ20gbm90IHN1cmUgYWJvdXQgUGNMaW51eE9TIGJ1 dCBpdCdzIGluIHRo
ZSBkbnN1dGlscyBwYWNrYWdlIG9uDQo+IGRlYmlhbi9VYnVudHUuDQoNCkFz IHlvdSBzYWlkIGVh
cmxpZXIsIGl0J3Mgbm90IG5lY2Vzc2FyeSB0byB1c2UgZGlnIHRvIGNoZWNr IHRoZSBpcCBhZGRy
ZXNzLiANClBpbmcgZG9lcyB0aGUgam9iLiANCj4gDQo+IEFsc28sIGFmdGVy IHlvdSBjaGFuZ2Ug
REIvVXNlciBwZXJtaXNzaW9ucyB3aXRoIEdSQU5UIHN0YXRlbWVudHMgaXQn cyBvZnRlbg0KPiBu
ZWNlc3NhcnkgdG8gZG8gYSAnRkxVU0ggUFJJVklMRUdFUzsnDQpUaGlzIEkg ZGlkbid0IGtub3cu
LiBJIGp1c3QgdHJpZWQgaXQsIHRob3VnaCwgYW5kIGl0IG1ha2VzIG5vIGRp ZmZlcmVuY2UuDQoN
Cj4gDQo+IEl0J3MgYWxzbyBlbnRpcmVseSBwb3NzaWJsZSB0aGF0IFBob3Rv biByZXNvbHZlcyB0
byAxMjcuMC4wLjEgaW4gd2hpY2ggY2FzZQ0KPiB5b3Ugd2lsbCBuZWVkICBH UkFOVCBmb3IgJ21p
Y2hhZWwnQCdsb2NhbGhvc3QnDQo+IElzIHRoZSBuYW1lIHBobw0KDQpbbWlj aGFlbEBwaG90b24g
fl0kIHBpbmcgcGhvdG9uDQpQSU5HIHBob3RvbiAoMTkyLjE2OC4xLjIwKSA1 Nig4NCkgYnl0ZXMg
b2YgZGF0YS4NCjY0IGJ5dGVzIGZyb20gcGhvdG9uICgxOTIuMTY4LjEuMjAp OiBpY21wX3NlcT0x
IHR0bD02NCB0aW1lPTAuMDQ3IG1zDQo2NCBieXRlcyBmcm9tIHBob3RvbiAo MTkyLjE2OC4xLjIw
KTogaWNtcF9zZXE9MiB0dGw9NjQgdGltZT0wLjA0NSBtcw0KDQoNCj4gdG9u IGxpc3RlZCBpbiAv
ZXRjL2hvc3RzID8NCj4gDQo+IEhvcGUgdGhhdHMgb2Ygc29tZSB1c2UNCj4g bWMNCj4gDQo+IE9u
IDUgSnVseSAyMDEwIDAzOjM1LCBNaWNoYWVsIFNhdHRlcndoaXRlIDxtaWNo YWVsQHdlYmxvcmUu
Y29tPiB3cm90ZToNCj4gPiBPbiBTdW5kYXksIEp1bHkgMDQsIDIwMTAgMDY6 MzY6MDAgcG0geW91
IHdyb3RlOg0KPiA+ID4gV2hhdCB1c2VyIGFyZSB5b3UgYXQgdGhlIHRpbWUg eW91IGFyZSBydW5u
aW5nIHRoZXNlIHRlc3RzLiAgV291bGQgSSBiZQ0KPiA+ID4gY29ycmVjdCBp biBndWVzc2luZyAn
cm9vdCc/DQo+ID4gPiANCj4gPiA+IFRoZSByZWFzb24gbG9jYWxob3N0IHdv cmtzIGlzIGJlY2F1
c2UsIGluIHNvbWUgZGlzdHJvcywgcm9vdCBpcw0KPiA+ID4gZW5hYmxlZCBs b2NhbGhvc3Qgd2l0
aCBubyBwYXNzd29yZCAuLiB3aGljaCBpcyBkYW5nZXJvdXMgZW5vdWdoLi4N Cj4gPiA+IGdyYW50
aW5nIHJvb3RAJyUiIHdvdWxkIGJlIGFuIGludml0YXRpb24gdG8gZGlzYXN0 ZXIuLg0KPiA+ID4g
DQo+ID4gPiBGcm9tIHRoYXQgc2FtZSBjb21tYW5kIGxpbmUsIHdoYXQgZG8g eW91IGdldCBmb3IN
Cj4gPiA+ICQgZGlnIHBob3Rvbg0KPiA+ID4gDQo+ID4gPiBZb3UgbGlrZWx5 IHdhbnQgdG8gbWFr
ZSBhIGdyYW50IHN1aXRhYmxlIHJmb3IgdGhhdCBuZXR3b3JrIGFkZHJlc3Mg Zm9yDQo+ID4gPiB0
aGUgdXNlciB5b3UgYXJlIHRyeWluZyB0byB1c2UuDQo+ID4gPiANCj4gPiA+ ICAtIG1pY2hhZWwg
ZHlrbWFuDQo+ID4gDQo+ID4gVGhpcyBzb3VuZGVkIGdvb2QsIGJ1dC4uLi4N Cj4gPiANCj4gPiAi
ZGlnIHBob3RvbiIgcmV0dXJucyAiY29tbWFuZCBub3QgZm91bmQiDQo+ID4g DQo+ID4gSSBsb2dn
ZWQgb250byB0aGUgc2VydmVyIGFzIHJvb3QgYW5kIGlzc3VlZCB0aGUgY29t bWFuZDoNCj4gPiAN
Cj4gPiBncmFudCBhbGwgcHJpdmlsZWdlcyBvbiAqLiogdG8gJ21pY2hhZWwn QCclJyBpZGVudGlm
aWVkIGJ5ID8/Pz87DQo+ID4gKD8/PyBpcyB0aGUgcGFzc3dvcmQsIGluIHF1 b3Rlcywgb2YgY291
cnNlKS4gSXQgcmVzcG9uZGVkDQo+ID4gDQo+ID4gICAgICAgIFF1ZXJ5IE9L LCAwIHJvd3MgYWZm
ZWN0ZWQgKDAuMDAgc2VjKQ0KPiA+IA0KPiA+IEkgc3RpbGwgY2FuJ3QgY29u bmVjdCB2aWENCj4g
PiANCj4gPiAgICAgICAgbXlzcWwgLWggcGhvdG9uIC11IG1pY2hhZWwgLXA/ Pz8/Pz8NCj4gPiAN
Cj4gPiBTdGlsbA0KPiA+IA0KPiA+ICAgICAgICAgRVJST1IgMjAwMyAoSFkw MDApOiBDYW4ndCBj
b25uZWN0IHRvIE15U1FMIHNlcnZlciBvbiAncGhvdG9uJw0KPiA+ICAgICAg ICAgKDExMSkNCj4g
PiANCj4gPiAtLQ0KPiA+IE15U1FMIEdlbmVyYWwgTWFpbGluZyBMaXN0DQo+ ID4gRm9yIGxpc3Qg
YXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNCj4gPiBU byB1bnN1YnNjcmli
ZTogICAgaHR0cDovL2xpc3RzLm15c3FsLmNvbS9teXNxbD91bnN1Yj1jbGFy a2VtN0BnbWFpbC5j
b20NCg0KLS0gDQpNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KRm9yIGxp c3QgYXJjaGl2ZXM6
IGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNClRvIHVuc3Vic2NyaWJl OiAgICBodHRwOi8v
bGlzdHMubXlzcWwuY29tL215c3FsP3Vuc3ViPWJ1cmhhbi5raGFsaWRAZ21h aWwuY29tDQoNCg==

Re: Why is Host option Failing? SOLVED

am 05.07.2010 21:03:24 von Michael Satterwhite

On Monday, July 05, 2010 01:17:57 pm burhan.khalid@gmail.com wrote:
> 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

Thanks much. This led me to find the problem in the server config. The bind-
address parameter was incorrect.

I appreciate the help everyone gave me. Thank you.
---Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Why is Host option Failing?

Re: Why is Host option Failing?

Re: Why is Host option Failing?

Re: Why is Host option Failing?

Re: Why is Host option Failing?

Re: Why is Host option Failing?

Re: Why is Host option Failing?

Re: Why is Host option Failing? *SOLVED*

Re: Why is Host option Failing? SOLVED