MySQL Bugs: #50398: Unable to login mysql via network PC

Bug #50398	Unable to login mysql via network PC
Submitted:	17 Jan 2010 17:56	Modified:	26 Feb 2010 7:08
Reporter:	Gaurav Shaha	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0.67	OS:	Other (Fedora 10)
Assigned to:		CPU Architecture:	Any
Tags:	login problem, timeout error, unable to login

Description:
We where using mysql since last 1 year but from 17 Jan 2010 we are not able to login in the mysql from network PC. Whenever i tried to start mysql service it is showing and error as "Timeout error occurred trying to stop MySQL Daemon."

How to repeat:
do know exact cause.

Please, send your my.cnf file content and the results of

uname -a
free

Linux commands.

---------------------------------
uname -a

Linux localhost.localdomain 2.6.27.5-117.fc10.x86_64 #1 SMP Tue Nov 18 11:58:53 EST 2008 x86_64 x86_64 x86_64 GNU/Linux
----------------------------------------
free
             total       used       free     shared    buffers     cached
Mem:       8195744    6460164    1735580          0      86500    4743836
-/+ buffers/cache:    1629828    6565916
Swap:      2048276          0    2048276

-----------------------------------------------
my.cnf

[mysqld]
port	= 3306
datadir = /var/lib/mysql
socket	= /var/lib/mysql/mysql.sock
default-storage-engine=INNODB
max_connections=1510
skip-locking
key_buffer = 512M
max_allowed_packet = 15M
table_cache = 768
sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 16M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
innodb_buffer_pool_size = 1024M 

user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186

my.cnf

Attachment: my.txt (text/plain), 1.32 KiB.

Thank you for the feedback.

Error  "Timeout error occurred trying to stop MySQL Daemon." shows you start mysqld using command `/etc/init.d/mysql restart` Please try to do what this command does manually, but with additional step:

/etc/init.d/mysql stop
Check with `ps -ef | grep mysqld` if mysqld is still running.
Wait when it stops if it is running or kill it.
/etc/init.d/mysql start

Please inform us if problem still exists.

Also would be good if you upgrade to version 5.0.89 as 5.0.67 is old and many bugs were fixed since.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".