List:General Discussion« Previous MessageNext Message »
From:seth Date:March 29 1999 10:53pm
Subject:Problem with --host paramter to mysql
View as plain text  
>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
Thread
Problem with --host paramter to mysqlseth30 Mar
Re: Problem with --host paramter to mysqlFred Lindberg30 Mar