Koozali.org: home of the SME Server

can't login mysql

rasara1

can't login mysql
« on: May 23, 2006, 03:40:11 AM »
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2

why reset mysql

Offline NickCritten

  • *
  • 245
  • +0/-0
can't login mysql
« Reply #1 on: May 23, 2006, 02:37:42 PM »
More info please!

Where does this error appear?
What did you do before it happened?
What have you done to figure out the problem for yourself?

etc. etc.
...
Nick

"No good deed goes unpunished." :-x...

cristi3k

I got this error ...
« Reply #2 on: October 13, 2006, 10:55:58 AM »
.. from installing some rpms.
here is a solution that worked for me:

cd /var/lib
chown mysql.root mysql
chmod 755 mysql

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: I got this error ...
« Reply #3 on: October 13, 2006, 01:48:15 PM »
Quote from: "cristi3k"
.. from installing some rpms.
here is a solution that worked for me:

cd /var/lib
chown mysql.root mysql
chmod 755 mysql
The above make me think you installed mysql RPM's am I correct? If you use webmail, check that this works properly as many issues in upgrading/altering mysql resulteed in broken webmail.

One tip for the future, describe problems as detailed as possible, saying stuff doesn't work won't give users on this forum not much to work with. It helps when you tell us what you did before, so if you installed RPM's, specify what RPM's, all actions taken and diagnosis you performed.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
Re: I got this error ...
« Reply #4 on: October 13, 2006, 02:42:29 PM »
Quote from: "cristi3k"
.. from installing some rpms.
here is a solution that worked for me:

cd /var/lib
chown mysql.root mysql
chmod 755 mysql


Interesting,

My /var/lib/mysql directory is owner:mysql group:mysql permissions:755
Regards,
William

IF I give advise.. It's only if it was me....