Mysql error 2002

Hello ALL,

Mysql is not working. I did every thing i know. Please help. I am a newbie to Mysql. these are the
errors i am getting.

tail -f /var/lib/mysql/XXX.3.com.err
050617 2:51:00 InnoDB: Error: unable to create temporary file; errno: 30
050617 2:51:00 Can't init databases
050617 2:51:00 Aborting

050617 2:51:00 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
050617 2:51:00 /usr/sbin/mysqld: Shutdown Complete

050617 02:51:00 mysqld ended




[/tmp]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[/tmp]# cat /etc/my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
tmpdir = /tmp
port = 3306
socket = /var/lib/mysql/mysql.sock

[/tmp]# service mysql stop
No mysqld pid file found. Looked for /var/lib/mysql/XXX.3.com.pid.


Some one help ASAP. Thank you.

Regards,
sak47

 

 

 

 

Top