MySQL won't start... was runnnig fine

[Chris Blackwell]

Hi,   I have been running 4.1.3 on redhat9, installed from the mysql rpm package.  It has been running great until the server crashed for an unknown reason 2 days ago.   now when ever i try to start mysql i get the following error in log   040812 09:52:34  mysqld started 040812  9:52:34  Warning: Asked for 196608 thread stack, but got 126976 040812  9:52:34  InnoDB: Error: unable to create temporary file 040812  9:52:34  InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File operation call: 'tmpfile'. InnoDB: Cannot continue operation. 040812 09:52:34  mysqld ended i have chown -R the /var/lib/mysql directory   -rw-rw----    1 mysql    mysql           0 Aug 12 09:59 innodb.status.4891 drwx--x--x    2 mysql    mysql        4096 Aug 11 09:57 mysql srwxrwxrwx    1 mysql    mysql           0 Aug 12 09:59 mysql.sock -rw-rw----    1 mysql    root          442 Aug 12 09:59 slim.err drwxr-xr-x    2 mysql    mysql        4096 Aug 11 09:57 test I had changed nothing in the server, apart from the unexplained crash everything was normal now i'm stuck anyone seen this error before ?   Regards Chris Blackwell Lead Web Developer UK City Directory Ltd Telephone: +44 (0)117 373 1465 Email: [EMAIL PROTECTED] This email is intended for the use of the named recipient(s) only. Any information contained within this message or any of its attachments may be confidential and privileged information.  Any unauthorized disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited.