Stack Overflow
Stack Overflow

Questions tagged [mysql.sock]

mysql.sock is the Unix socket file that the MySQL server uses for communication with local clients.

mysql.sock is the Unix socket file that the MySQL server uses for communication with local clients.

http://dev.mysql.com/doc/refman/5.7/en/problems-with-mysql-sock.html

43 questions
32
votes
7 answers

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I am trying to run mysql client on my terminal. I have installed the latest mysql gem. ➜ ~ git:(master) ✗ ruby -v ruby 1.8.7 (2010-01-10 patchlevel 249) [universal-darwin11.0] ➜ ~ git:(master) ✗ rails -v Rails 2.3.14 ➜ ~…
Ava
  • 5,783
  • 27
  • 58
  • 86
31
votes
5 answers

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

when connecting to mysql database in Django ,I get the error. I'm sure mysql server is running. /var/run/mysqld/mysqld.sock doesn't exist. When I run $ find / -name *.sock -type s, I only get /tmp/mysql.sock and some other irrelevant output. I…
robert
  • 598
  • 1
  • 5
  • 12
13
votes
8 answers

Yosemite - MAMP - Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)

I have problem when I try to connect to MySQL MAMP : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2) I'm doing research but I have not found a solution to my problem, I try to…
Matyas
  • 133
  • 1
  • 1
  • 9
11
votes
6 answers

can't start mysqld on centos because I cant find mysql.sock

Hello when I try to start up my mysqld I get this error: [root@localhost /]# service mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: …
Yannick
  • 111
  • 1
  • 1
  • 3
8
votes
1 answer

SQLSTATE[HY000] [2002] Not a directory when doctrine:schema:create

I'm currently programming in Symfony2 (following this tutorial: tutorial.symblog.co.uk, and when I execute a: php app/console doctrine:schema:create I get: [PDOException] SQLSTATE[HY000] [2002] Not a directory Here is my parameters.yml…
xanesis4
  • 338
  • 1
  • 7
  • 15
7
votes
5 answers

mysql.sock is not created OSX

I run mysql on OSX, now when I restart my computer it does not create the mysql.sock, meaning that all my connections gives me a error 2002. anyone knows how to prevent this?
nivanka
  • 1,352
  • 6
  • 23
  • 36
7
votes
7 answers

Database connection "Mysql" is missing and mysql.sock is missing

I was trying to generate model code from cake command line tool. But got this issue. Warning Error: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in…
ihaider
  • 1,290
  • 4
  • 19
  • 38
6
votes
3 answers

MySQL hell... can't connect to database /tmp/mysql.sock

Update: I've STOPPED the older mysql process which was running and causing some confusion. Now I think I have only the newer (5.1.40) version running. BUT, it's pointing to the wrong data file. It's pointing to a default install data file and I'd…
Meltemi
  • 37,979
  • 50
  • 195
  • 293
5
votes
0 answers

For homebrew mysql installs, how to fix mysql.sock path?

I am on macOS 10.12.3. Installed and running MySQL through Homebrew. Whenever i try to start MySQL with brew services start mysql or sudo mysql.server start command on terminal, it starts. Following is my my.cnf file residing into…
Partho Biswas
  • 2,290
  • 1
  • 24
  • 39
5
votes
3 answers

XAMPP mysql.sock is missing

I installed XAMPP from the apachefriends.org following these instructions: http://www.apachefriends.org/en/xampp-linux.html#377 . The problem is that file /opt/lampp/var/mysql/mysql.sock is missing. How can i get this file? Thing is I want to run an…
Jacob Krieg
  • 2,834
  • 15
  • 68
  • 140
4
votes
3 answers

MySQL suddenly stopped LAMP stack

I have been using the LAMP stack on a Ubuntu setup. It has been working fine, set up multiple databases everything is going fine, and then suddenly this morning I started getting database errors from the webpage I was using, then trying to access…
elzaer
  • 729
  • 7
  • 25
3
votes
3 answers

Missing mysql.sock; yielding OperationalError: (2002, "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)")

Firstly, I swear that I have looked at every single question that references this error. Nearly every solution someone offers is different, and no one seems to understand the systemic reasons for the error. What I, and many people on the web who…
jesuis
  • 2,246
  • 3
  • 19
  • 17
2
votes
1 answer

Doctrine 2 command line tool; MAMP and mysql.sock

I grabbed the CI2/Doctrine2 from Wildly Inaccurate. I'm trying to start using it, but before I'm actually getting to work with it, I wanted to make sure everything works. However, when I try the command line tool, I run into the following error: $…
Joris Ooms
  • 11,880
  • 17
  • 67
  • 124
2
votes
4 answers

mysql.sock does not exist error in fresh install of MySQL on Arch Linux

I'm trying to use MySQL on Arch Linux. it is already installed but this error comes up when I try to connect: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such…
tino
  • 151
  • 3
  • 9
2
votes
0 answers

mysql wont start post install OSX El Capitan

Im trying to get mysql running on my OSX machine. I downloaded the DMG from here: http://dev.mysql.com/downloads/mysql/ After downloading I go to Preferences -> MySQL -> Start MySQL Server. It will wait for a couple seconds and then go back to "The…
mogoli
  • 2,153
  • 6
  • 26
  • 41
1
2 3