LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 11-10-2006, 06:34 PM   #1
jamesjoy
LQ Newbie
 
Registered: Aug 2005
Location: Louth, Ireland
Distribution: FC 4
Posts: 27

Rep: Reputation: 15
Unhappy 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.
 
Old 11-11-2006, 03:32 AM   #2
paulsm4
Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
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
 
Old 11-11-2006, 04:47 PM   #3
jamesjoy
LQ Newbie
 
Registered: Aug 2005
Location: Louth, Ireland
Distribution: FC 4
Posts: 27

Original Poster
Rep: Reputation: 15
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't get remote access to mysql server hughes28105 Suse/Novell 6 09-17-2005 10:07 PM
Sarge mysql-server Access denied for user: root@localhost infinity432 Linux - Software 2 05-19-2005 12:42 AM
How to access mysql server on local server ? Tancrede Linux - Newbie 2 04-09-2005 01:12 PM
MySQL access problems! gbg Linux - Software 10 08-22-2003 04:38 PM
MySQL access denied problems ?? huno Linux - General 1 05-16-2002 11:30 AM


All times are GMT -5. The time now is 03:08 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration