Mysql Access Problems - Server Not responding
 

I have been using apache with mysql very successfully over the last couple of months. Today i tried to install postgresql, which caused Mysql to stop working. I ve since removed postgresql and its still not working.

Mysql fails to load at boot time. When I try access it via the shell I get the following error...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

With Phpmyadmin...

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

The contents of the mysql log is ...

061110 23:27:20 mysqld started
/usr/libexec/mysqld: Can't read dir of '/tmp/' (Errcode: 13)
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibvGJU8h' (Errcode: 13)
061110 23:27:20 InnoDB: Error: unable to create temporary file; errno: 13
061110 23:27:20 [ERROR] Can't init databases
061110 23:27:20 [ERROR] Aborting

061110 23:27:20 [Note] /usr/libexec/mysqld: Shutdown complete

061110 23:27:20 mysqld ended

As a result I tried changing the permissions of tmp but didnt seem to work, not 100%sure how to change permissions tried this...

# chmod a+rw /tmp

Any help would be great
Thanks.

Hi -

Your "chmod" command basically seems OK, but there are a few potential gotcha's. Please try this:
If you don't, try these three steps:
'Hope that helps .. PSM

No unfourtunately that did help still getting the same error messages. The output of
ls -ls /tmp is...

drwxrwxrwx 13 root root 4096 Nov 11 21:43 /tmp

If thats any help.

Maybe i should try reinstalling mysql?

Thanks