what is the mysql.sock file

[bignester]

where can i find the mysql.sock file or how do i make one

[Dolda2000]

The mysql.sock is the socket that mysqld creates for programs to connect to. I think it usually is /var/lib/mysql/mysql.sock. At least it is on my system. mysqld automatically creates it upon startup.

[mOdEtWo]

mysqld automatically creates it upon startup.

Sorta off-topic, but what the hell...

I had just updated my RedHat 8.0 system with the latest patch, when my MySQL database stopped working. I looked in /var/lib/mysql, and I couldn't find the mysql.sock file. I got kinda stressed, thinking that my databased were f*cked up, but then I rebooted and the .sock file were replaced.

Have no idea, guess it had something to do with the MySQL getting updated or something...

[Dolda2000]

You didn't just try "service mysqld restart"? You know, an advantage of Linux/UNIX is that unless you're doing kernel upgrades, you never need to reboot.

[mOdEtWo]

You didn't just try "service mysqld restart"?

Thanks for the tip, I'm still learning!

[moradoxy]

Only delete de log files ib_logfile0, ib_logfile1 and ibdata1 in the /var/lib/mysql directory and then type:

"mysqld_safe --user=mysql &"

and automatically the mysql.sock file will be create and the news logs files.

[swemic]

Only delete de log files ib_logfile0, ib_logfile1 and ibdata1 in the /var/lib/mysql directory and then type:

"mysqld_safe --user=mysql &"

and automatically the mysql.sock file will be create and the news logs files.

Wow!!! Do not this if you are using InnoDB as db. Then you'll loose a lot of information. Deleting those files that is.

[nabonita]

Hi,

Somehow the mysqld.pid (/var/run/) & mysqld.sock (/tmp/) files got deleted deleted. Consequently, mysql is not getting started. I'm finding it difficult to restore the files.

Require your urgent attention.

Thanks in advance

--
Nabonita

[beachboy]

You know, an advantage of Linux/UNIX is that unless you're doing kernel upgrades, you never need to reboot.

That is the best reason for anybody to get away from Microsoft Windows! Very well said Dolda2000.

[ox]

I am in the exact same fix. I upgraded to mysql 5.1 and haven't been able to restart the server. I do not have a mysql.sock file and I am unable to generate on. The server fails with this error at boot up.

Starting MySQLCouldn't find MySQL manager or server        [FAILED]

When I do

mysql -u root -p

I get

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