Solved

Deleted  /tmp/mysql.sock and mysql won't work now

Posted on 2016-08-19
3
21 Views
Last Modified: 2016-09-26
I deleted  /tmp/mysql.sock because I thought I was just cleaning up a junk folder.  Well, mySQL won't work now.  I've tried stopping and starting the daemon multiple times, as some suggest, but it doesn't re-create the file.

Any ideas?
0
Comment
Question by:hrolsons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Accepted Solution

by:
hrolsons earned 0 total points
ID: 41763101
Turns out I had wrong permissions on the newly created /tmp dir:

chmod 777 /tmp

Solved the problem.
0
 
LVL 78

Assisted Solution

by:arnold
arnold earned 500 total points
ID: 41763984
usually, mysql.sock should not be in /tmp it should be in /var/lib/mysql/mysql.sock
your /etc/my.cnf

socket=/var/lib/mysql/mysql.sock

.....
0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question