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 > > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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
