Hi,
Try to put in the /etc/hosts the IP address of the machine which must
connect to the server.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Nicholas Calugar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 22, 2002 9:11 AM
Subject: RedHat 8 and mysql-server-3.23.52-3
> 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
>
>
---------------------------------------------------------------------
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
