Mysql Access Problems

jamesjoy · 11-10-2006, 05:34 PM

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.

paulsm4 · 11-11-2006, 02:32 AM

Hi -

Your "chmod" command basically seems OK, but there are a few potential gotcha's. Please try this:

Quote:

ls -ld /tmp
drwxrwxrwt 5 root root 52224 Nov 10 19:06 /tmp
<= YOU SHOULD SEE SOMETHING LIKE THIS: OWNER, GROUP & WORLD HAVE READ, WRITE AND EXECUTE

If you don't, try these three steps:

Quote:

su - root
<= BECOME "ROOT" USER
umask 0
<= SET YOUR "UMASK" TO ZERO (POTENTIAL "GOTCHA" #1)
chmod 777 /tmp
<= EXPLICITLY SET PERMISSIONS

'Hope that helps .. PSM

jamesjoy · 11-11-2006, 03:47 PM

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