here is my my.cnf contents:
[mysqld]
skip-bdb
thread_concurrency=8
table_cache=64M
innodb_buffer_pool_size=256M
thread_cache_size=4M
join_buffer_size=8M
query_cache_size=64M
max_allowed_packet=100M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#innodb_force_recovery = 4
#innodb_data_file_path = ibdata1:100M:autoextend:max:500M;ibdata2:100M:autoextend
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
i added the following trying to fix it, but it didn't :
#innodb_force_recovery = 4
#innodb_data_file_path = ibdata1:100M:autoextend:max:500M;ibdata2:100M:autoextend
---------------------
mysql log
[root@i1331 ~]# tail -f /var/log/mysqld.log
100805 10:53:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
100805 10:53:52 [Note] /usr/libexec/mysqld: Normal shutdown
100805 10:53:54 InnoDB: Starting shutdown...
A mysqld process already exists at Thu Aug 5 10:54:52 GMT 2010
A mysqld process already exists at Thu Aug 5 10:57:08 GMT 2010
A mysqld process already exists at Thu Aug 5 10:59:54 GMT 2010
A mysqld process already exists at Thu Aug 5 11:04:17 GMT 2010
A mysqld process already exists at Thu Aug 5 11:36:56 GMT 2010