[resolved] MySQL Socket

AH-Dominic

[root@website mysqld]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

The socket file doesn't exist, and when trying to start MySQL, I receive "MySQL Daemon cannot start".

Any idea why? I've tried removing/reinstalling MySQL but still getting that.

netomx

@dominicl said: '/var/lib/mysql/mysql.sock' (2)

Do you have MySQL SERVER installed?

AH-Dominic

Yes. mysql-server is installed

vedran

Try to start mysqld manually (just type mysqld), it should either start or give you a reason why it won't start. Or look at your logs

netomx

try

service mysqld start

if not, change mysql for mysql or mysql-server

AH-Dominic

[root@website mysqld]# mysqld
-bash: mysqld: command not found

[root@website mysqld]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

AH-Dominic

[root@website mysqld]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]

Maounique

look in it's log, it usually says what was wrong.
M

netomx

@dominicl said: Starting mysqld: [FAILED]

check the mysql logs, in /var/log

AH-Dominic

Thanks, can be closed now..

yomero

Expand: Thanks, can be closed now..

LOL?
So what was the flaw???

vedran

xkcd.com/979/

nabo

@yomero said: LOL?

Well, there are guys eating the meal without paying afterwards. And there are guys asking for help and others free time and not saying thanks and telling what helped to solve the situation.

yomero

@vedran said: xkcd.com/979/

Hahaha! Wonderful...

joepie91

@dominicl said: Thanks, can be closed now..

It's pretty rude to simply say 'it's fixed', and not elaborate on what the issue was.

AH-Dominic

Alright, alright sorry. Was an incompatibility issue, on my part.

netomx

@dominicl said: Alright, alright sorry. Was an incompatibility issue, on my part.

as?