Arch Linux

CheatCat

Member

Registered: 2009-07-10

Posts: 54

[SOLVED] MYSQL error about socketfiles!

Hello, I installed mysql with pacman but cannot figure out how to run it!
Running mysql_secure_installation give me this error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

/etc/rc.d/mysqld start just say FAIL
/var/lib/mysql and all files there are owned by mysql, mysql

Can anyone please help me!

Last edited by CheatCat (2010-06-24 19:29:33)

Sin.citadel

Member

Registered: 2008-01-22

Posts: 267

Re: [SOLVED] MYSQL error about socketfiles!

looks like mysql isnt running, check /etc/mysql/my..cnf to check if any settings needs to be altered. also, it might be that the file <hostname>.pid exists in /var/lib/mysql , if there is then you should remve it and then try starting mysql.

CheatCat

Member

Registered: 2009-07-10

Posts: 54

Re: [SOLVED] MYSQL error about socketfiles!

I think I solved it by just runnig this:

sudo /etc/rc.d/mysqld start

Forgotted sudo before, clever..

Last edited by CheatCat (2010-06-24 19:29:13)