On Tue, 22 Oct 2002, Gelu Gogancea wrote: > Hi, > No.On the server machine.The "hosts" is the way for resolving hostnames.In > other Unix system, like SCO, to put the IP address and the alias in hosts is > indispensable.
Well, I meant that the client machine in this case seems to be a *NIX, so the /etc/hosts of _that_ machine should be updated. Of course, depending on where the error comes from. In this case it seems to be on the client side - although the client computer seems to be running Unix. Iikka > ----- Original Message ----- > From: "Iikka Meriläinen" <[EMAIL PROTECTED]> > To: "Gelu Gogancea" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, October 22, 2002 3:01 PM > Subject: Re: RedHat 8 and mysql-server-3.23.52-3 > > > On Tue, 22 Oct 2002, Gelu Gogancea wrote: > > > Hi, > > > > Try to put in the /etc/hosts the IP address of the machine which must > > connect to the server. > > > Hi! > > I guess you mean the /etc/hosts on the client machine? Right? > > Also, updating your real DNS records might prove useful in the long run. > > Best regards, > Iikka > > > > I have recently installed RedHat 8 and the following RPMs: > > > > > > [root@chimp etc]# rpm -q mysql > > > mysql-3.23.52-3 > > > > > > [root@chimp etc]# rpm -q mysql-server > > > mysql-server-3.23.52-3 > > > > > > I am having problems connecting to the server remotely through the TCP > > > connection, the firewall is completely disabled: > > > > > > njc2@hilton njc2/mysql/bin> mysqladmin -h chimp.battlemonkey.net -p > > > version > > > Enter password: > > > mysqladmin: connect to server at 'chimp.battlemonkey.net' failed > > > error: 'Lost connection to MySQL server during query' > > > > > > I can connect fine from the localhost to the socket: > > > > > > [root@chimp etc]# mysqladmin version -p > > > Enter password: > > > mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 > > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > > > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > > > and you are welcome to modify and redistribute it under the GPL license > > > > > > Server version 3.23.52-log > > > Protocol version 10 > > > Connection Localhost via UNIX socket > > > UNIX socket /var/lib/mysql/mysql.sock > > > Uptime: 2 min 21 sec > > > > > > Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 > > > Open tables: 0 Queries per second avg: 0.007 > > > > > > This is the first part of /etc/my.cnf. > > > > > > [client] > > > #password = your_password > > > port = 3306 > > > socket = /var/lib/mysql/mysql.sock > > > > > > # Here follows entries for some specific programs > > > > > > # The MySQL server > > > [mysqld] > > > port = 3306 > > > socket = /var/lib/mysql/mysql.sock > > > skip-locking > > > set-variable = key_buffer=16M > > > set-variable = max_allowed_packet=1M > > > set-variable = table_cache=64 > > > set-variable = sort_buffer=512K > > > set-variable = net_buffer_length=8K > > > set-variable = myisam_sort_buffer_size=8M > > > log-bin > > > server-id = 1 > > > > > > Could it be something to do with the startup/stop script because I > > > noticed something else odd. The script works for starting the daemon: > > > > > > [root@chimp etc]# /sbin/service mysqld start > > > Starting MySQL: [ OK ] > > > > > > But not for stopping it: > > > > > > [root@chimp etc]# /sbin/service mysqld stop > > > Stopping MySQL: [FAILED] > > > > > > I can only stop the daemon with: > > > > > > [root@chimp etc]# mysqladmin -p shutdown > > > > > > Thanks in advance, > > > > > > nicholas calugar > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php