mysql command line do not accept host param

[Daniele Cruciani]

mysql -h myhost.com -u root -proot
ERROR 2005 (HY000): Unknown MySQL server host '' (2)

ProblemType: Bug
Architecture: amd64
Date: Wed Feb 17 11:33:18 2010
DistroRelease: Ubuntu 10.04
Logs.var.log.daemon.log:

Logs.var.log.kern.log:

MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: False
NonfreeKernelModules: nvidia
Package: mysql-client 5.1.41-3ubuntu4
PackageArchitecture: all
ProcEnviron:
 LANGUAGE=it_IT.UTF-8
 PATH=(custom, user)
 LANG=it_IT.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.32-13.18-generic
SourcePackage: mysql-dfsg-5.1
Uname: Linux 2.6.32-13-generic x86_64

[Chuck Short (zulcss)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. Please answer these questions:
1. Is this reproducible?
2. If so, what specific steps should we take to recreate this bug? Be as detailed as possible.
This will help us to find and resolve the problem.

[Daniele Cruciani (daniele-smartango)]

in the orginal message, this:
mysql -h myhost.com -u root -proot
ERROR 2005 (HY000): Unknown MySQL server host '' (2)

represent command line, followed by return message, that means: specify anything else than localhost mysql client shell utility give the message:
ERROR 2005 (HY000): Unknown MySQL server host '' (2)

It appear that /usr/bin/mysql do not parse command line.
It is the same specifying --host=... or -hmyhost.com

1 step to reproduce: mysql command with host not equal to localhost

[Daniele Cruciani (daniele-smartango)]

solved after downgrade to 5.1.41-3ubuntu7

[Arjan (iafilius)]

Hello,

running lucid 64 bits (beta) ive got:

me@laptop:~$ mysql -hwww.xs4all.nl
ERROR 2005 (HY000): Unknown MySQL server host '' (2)
me@laptop:~$

the host is just an example, i seem to get it on any host.
i see it _does_ a dns lookup, but refuses to connect.

any idea's or workaround perhaps?

[Daniele Cruciani (daniele-smartango)]

It seems the one reported by me ...
does
> mysql --version
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1

is 5.1.41? or is 7...? if so downgrade mysql-client package

[Arjan (iafilius)]

Hello, yes it's exactly that version:

$ mysql --version
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1

however, lucid (beta) seems not to have a lower version, or i might overlook it.

$ apt-cache search mysql-client
mysql-client - MySQL database client (metapackage depending on the latest version)
mysql-client-5.1 - MySQL database client binaries
mysql-client-core-5.1 - MySQL database core client binaries
mysql-cluster-client - MySQL database client (metapackage depending on the latest version)
mysql-cluster-client-5.1 - MySQL database client binaries
torrentflux - web based, feature-rich BitTorrent download manager

Regards,

[Sune Keller (sune-keller)]

I was able to reproduce this issue in lucid final, whilst down-grading libmysql-client16 from 5.1.41-3ubuntu12.1 to 5.1.41-3ubuntu7 solves the issue for now.