search

TablePlus / DBngin

DB Engine
https://dbngin.com
995 stars 19 forks source link

Trying to connect with WordPress: "No such file or directory in ..." #68

Closed simplenotezy closed 3 years ago

simplenotezy commented 3 years ago

Please fill out the detail below, it helps me investigate the bug:

  1. Driver (Ex: PostgreSQL 10.0): MySQL 8.0.19

  2. DBngin build number: Version 3.4 (36)

  3. macOS version:11.3.1 (20E241)

  4. The steps to reproduce this issue:

1) Install valet (for PHP management + domain routing) on a fresh M1 macbook 2) Install dbngin 3) Create default database using MySQL 8.0.19 on port 3306 4) Test I can connect locally (using Sequel ACE client) - it works great. 5) Import my tables 6) Try to access local wordpress.test domain, it will fail with error: No such file or directory image

I have verified that I can connect using the same credentials on the client, and it works fine.

simplenotezy commented 3 years ago

I tried to see what was listening on port 3306, and this is what I got:

➜  project git:(develop) ✗ sudo lsof -i ':3306'
Password:
COMMAND    PID                USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME
Sequel     537 mf   18u  IPv6 0xa25d3ac8c38c2b6d      0t0  TCP localhost:49635->localhost:mysql (ESTABLISHED)
Sequel     537 mf   19u  IPv6 0xa25d3ac8d9718b8d      0t0  TCP localhost:49636->localhost:mysql (ESTABLISHED)
mysqld    5274 mf   31u  IPv6 0xa25d3ac8c38c052d      0t0  TCP *:mysql (LISTEN)
mysqld    5274 mf   38u  IPv6 0xa25d3ac8c38c250d      0t0  TCP localhost:mysql->localhost:49633 (ESTABLISHED)
mysqld    5274 mf   39u  IPv6 0xa25d3ac8c38bf20d      0t0  TCP localhost:mysql->localhost:49635 (ESTABLISHED)
mysqld    5274 mf   41u  IPv6 0xa25d3ac8d971786d      0t0  TCP localhost:mysql->localhost:49636 (ESTABLISHED)
TablePlus 5570 mf   17u  IPv4 0xa25d3ac8cc04a835      0t0  TCP localhost:49633->localhost:mysql (ESTABLISHED)
simplenotezy commented 3 years ago

Using port 127.0.0.1 instead of localhost seem to have resolved the issue