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
