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

Question

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 [/Users/test/Google_WWW/project_name/lib/Cake/Model/Datasource/Database/Mysql.php, line 177]

Error: Database connection "Mysql" is missing, or could not be created. (although it's showing that mysql database is connected at localhost in cakephp directory)

I'm using MAMP.

I searched a lot and found some solutions. For instance,this CakePHP: No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)

or I can also make a symbolic link of mysql.sock.

/Applications/MAMP/tmp/mysql/mysql.sock (not present in directory)

But before i do anything, the problem is mysql.sock file isn't present in this directory. I have tried re-installing the MAMP but still no mysql.sock.

Please help me solve this problem ? Can I create my own mysql.sock file..?

Edit: My db config

public $default = array(
    'datasource' => 'Database/Mysql',
    'persistent' => false,
    'host' => 'localhost',
    'login' => 'root',
    'password' => 'root',
    'database' => 'db_name',
    'prefix' => ''
);

edited my question, one thing I must say that database is connected without any issues. But for creating model via cakephp cli, it uses mysql.sock that's not present in mamp folder I mentioned. — ihaider, Oct 11 '13 at 15:54

Chuck Burgess · Accepted Answer · 2014-12-16T15:51:54.967

11

MAMP is strange when it comes to mysql. Chances are you need to set up a symbolic link so it knows where to find it. Something like:

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

edited Dec 16 '14 at 15:51

answered Oct 12 '13 at 00:08

Chuck Burgess

11,600
5
41
74

Thanks for the reply. I did create a symbolic link but my problem wasn't solved. – ihaider Oct 12 '13 at 19:05
1

To use it with php-cli, after creating the symbolic link, edit your php.ini: `pdo_mysql.default_socket= /tmp/mysql.sock`, `mysql.default_socket = /tmp/mysql.sock`, `mysqli.default_socket = /tmp/mysql.sock` – Seb33300 Apr 29 '14 at 13:56
the file is not created at all in my case. can you please tell me how to get mamp to generate the file? but phpmyadmin works perfectly fine – Harsha M V Jun 13 '14 at 03:02
The blog link above does not work. Also this symlink solution is aimed at MAMP, not MAMP PRO – geoidesic Dec 13 '14 at 09:47
1

bravo, your solution really work. i stuck in this problem for almost 2 weeks – Sruit A.Suk Dec 14 '21 at 02:11

score 4 · Answer 2 · answered Oct 15 '13 at 12:15

After searching and trying a lot of things I finally managed to solve my problem. The answer Chuck Burgess given above could solve the problem, but my scenario was little different that I wasn't able to see mysql.sock file at:

    /Applications/MAMP/tmp/mysql/mysql.sock

I thought my mysql.sock was missing but actually it was there and hidden (THAT's STRANGE! I WENT TO THAT FOLDER using CLI AND SAW THAT). I'm using MAC and files starting with '.' are usually HIDDEN but don't know why mysql.sock was hidden so what I did is in my database configuration file I added 1 parameter (unix_socket) and my problem was solved.

   'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock'

same here its hidden and can see it via cli. but when i add the unix_socket still i dont get connected. — Harsha M V, Jun 13 '14 at 03:08

score 1 · Answer 3 · answered May 01 '15 at 14:34

1

In my case it was because I was calling the wrong version of PHP. I.e. I was using /usr/bin/php which when MAMP Pro's php is /Applications/MAMP/bin/php/php5.3.29/bin/php

answered May 01 '15 at 14:34

geoidesic

4,649
3
39
59

Man how do you do this – Monclee Mar 25 '16 at 08:56

score 0 · Answer 4 · answered Nov 02 '14 at 18:44

I've been struggling with this the whole weekend and finally solved it. Turns out that the php.ini is pointing to a non-existing "extensions dir". Create a phpinfo() file and look at the value of this field: extensions_dir

I noticed that in the mamp php installed folder there is a no-debug-non-zts-20131226 folder, which is different from the value shown in the phpinfo(). What I did was to clone this folder and changed the name to the value of the phpinfo(). Probably you could modify the php.ini file but I didn't want to.

I see that you solved your problem but mine was different so I'm posting this answer to help future googlers looking for a similar problem.

Hope this helps.

score 0 · Answer 5 · edited Oct 20 '16 at 19:04

0

In my case the problem appear just after a power outage. So I fixed it by deleting the /Applications/MAMP/tmp/mysql/mysql.pid file and restarting MAMP.

edited Oct 20 '16 at 19:04

Mike

23,542
14
76
87

answered Oct 17 '16 at 23:26

Leonardo Correa

170
5

this broke my mamp :-( – rcpfuchs Mar 15 '17 at 06:10

score 0 · Answer 6 · answered Oct 25 '16 at 14:30

0

With MAMP create a symbolic link in the folder /var/mysql/:

sudo ln -n /Applications/MAMP/tmp/mysql/mysql.sock /var/mysql/mysql.sock

answered Oct 25 '16 at 14:30

Fabien Thetis

1,666
15
11

score 0 · Answer 7 · edited Aug 22 '20 at 15:45

0

Same problem here, but managed to resolve it connecting to IP:Port, not socket.

'host' => '127.0.0.1', //use 172.0.0.1 instead of localhost
'port' => '8889', //default MAMP MySQL devel port, default production port is 3306

and forget about socket connection.

edited Aug 22 '20 at 15:45

David Buck

3,752
35
31
35

answered Aug 22 '20 at 11:23

Chelu Gómez-Pardo

1

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

7 Answers7

Linked