>Description:
mysql --host=name does not name resolve properly
How-to-repeat shows that `mysql` can make a connection
and --host=ip works fine. But --host=name-that-corresponds-to-IP
does not work.
>How-To-Repeat:
[seth@pc126] $ hostname
pc126.psy.aau.dk
[seth@pc126] $ mysql --host=pc126.psy.aau.dk
ERROR 2005: Unknown MySQL Server Host (pc126.psy.aau.dk) (2)
[seth@pc126] $ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 715 to server version: 3.22.20a-log
[seth@pc126] $ mysql --host=130.225.10.126
ERROR 1045: Access denied for user: 'seth@' (Using password: NO)
[seth@pc126] $ mysql --host=130.225.10.126 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 717 to server version: 3.22.20a-log
>Fix:
See How-To-Repeat
>Submitter-Id: <submitter ID>
>Originator: Seth Chaiklin
>Organization:
>
>MySQL support: [none]
>Synopsis: ERROR 2005, problem with --host=name to mysql
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.22.20a (TCX binary)
>Server: /usr/bin/mysqladmin Ver 7.8 Distrib 3.22.20a, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.20a-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 7 days 9 hours 36 min 10 sec
Threads: 1 Questions: 11626 Slow queries: 0 Opens: 1261 Flush tables: 1 Open tables:
17
>Environment:
System: Linux pc126.psy.aau.dk 2.0.36 #1 Sun Mar 14 13:25:43 CET 1999 i586 unknown
Architecture: i586
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.7.2.3/specs
gcc version 2.7.2.3
Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc'
CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static'
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary'
--enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared
Perl: This is perl, version 5.004_03
