mysql client connection hostname question

Question

Have a question that I can't seem to find an answer for. I am trying to connect to a remote database. I type in the following to my Ubuntu shell:

mysql -u test -h mysql.domain.com -p

mysql asks for my password and then outputs the following:

ERROR 1045 (28000): Access denied for user 'test'@'externalit.domain.com' (using password: YES)

The problem is that I am not on externalit. I am on a completely different host. I think that the server I am on was cloned from externalit, but I didn't set the server up. My question: does mysql have a conf file or other setting that may be automatically entering an incorrect hostname? Can I change this?

MBCook · Accepted Answer · 2010-01-06 22:23:38Z

3

That's the name that the server thinks goes with your IP address. It could be do to a DNS setting (it's trying a reverse-DNS), or something in the /etc/host file (mapping that IP to that host).

answered Jan 6, 2010 at 22:23

MBCook

14.5k7 gold badges40 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

TCCV Over a year ago

Thanks, I thought of this and did a dig and the externalit FQDN resolves to a different IP. If it is the case that it's just DNS output, then I guess the server admin has some work to do...

Darth.Vader Over a year ago

@mbcook - seeing a similar problem. I don't have an /etc/host file on my machine.. Any other thoughts on what I could try?

DeveloperChris · Accepted Answer · 2010-01-07 03:13:09Z

2

You need to make sure the reverse DNS on the machine you are connecting from matches the address for the user. If you are on a shared IP or can't control the reverse DNS then change the permissions on the user to 'test'@'%' this will allow anyone from any ip address connect as long as they have the correct username/password pair. of course this opens up some security issues.

You can prevent mysql from doing reverse lookups and then use 'test'@'123.123.123' as the user/host but unless you are on a fixed IP that could cause issues.

DC

answered Jan 7, 2010 at 3:13

DeveloperChris

3,4662 gold badges27 silver badges40 bronze badges

Comments

Roland Bouman · Accepted Answer · 2010-02-12 08:32:56Z

2

Try adding a protocol option:

mysql -u test -h mysql.domain.com --protocol=tcp -p

and/or try adding a port explicitly:

mysql -u test -h mysql.domain.com -P3306 --protocol=tcp -p

(see: http://dev.mysql.com/doc/refman/5.1/en/mysql-command-options.html#option_mysql_protocol)

edited Feb 12, 2010 at 8:32

answered Jan 6, 2010 at 22:23

Roland Bouman

32.1k8 gold badges69 silver badges69 bronze badges

2 Comments

Nathan Over a year ago

Same here, for the same DNS-related issue.

lxg Over a year ago

Adding the protocol (even without hostname, as I am on localhost) did the trick.

Collectives™ on Stack Overflow

mysql client connection hostname question

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related