Connection through socket fails on Mac

What issue or error are you experiencing?

Cannot connect any database apps to the LocalWP database.

I’ve done this for years on my iMac. I got a new Mac Studio and it’s no longer working. I’m getting the same results in Navicat and Sequel Ace.

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

  1. Create new connection in Navicat.
  2. Set host, port, username, and password on General Tab.
  3. On Advanced tab, check “Use socket file” and paste socket path from Local.
  4. Click “Test Connection”


System Details

  • Local Version: Version 9.0.3+6684

  • Operating System (OS) and OS version: macOS Sonoma 14.5

Mac Studio
M2 Ultra

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

{“class”:“addIpcAsyncListener”,“level”:“warn”,“message”:“Duplicate callback appears to be getting added to connectManifestWpeService:create”,“stringifiedCallback”:“(e,t,i,n,s,r,a,o)=>this.create(e,t,i,n,s,r,a,o)”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:08.346Z”}
{“level”:“warn”,“linuxEdition”:null,“localVersion”:“9.0.3+6684”,“message”:“Electron Event ready”,“osArch”:“arm64”,“osPlatform”:“darwin”,“osRelease”:“23.5.0”,“timestamp”:“2024-06-01T19:43:08.612Z”,“windowsEdition”:null}
{“class”:“Process”,“level”:“warn”,“message”:“AH00558: httpd: Could not reliably determine the server’s fully qualified domain name, using Marks-Mac-Studio.local. Set the ‘ServerName’ directive globally to suppress this message”,“process”:“httpd”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:17.739Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2024-06-01T19:43:17.860969Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld (mysqld 8.0.16) starting as process 6037”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:18.009Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2024-06-01T19:43:17.861766Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:18.009Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2024-06-01T19:43:17.862195Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for %%site.runData%%/mysql/data/ is case insensitive”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:18.009Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2024-06-01T19:43:18.002053Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:18.010Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2024-06-01T19:43:18.009361Z 0 [System] [MY-010931] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/darwin/bin/mysqld: ready for connections. Version: ‘8.0.16’ socket: ‘%%site.runData%%/mysql/mysqld.sock’ port: 10018 MySQL Community Server - GPL.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2024-06-01T19:43:18.010Z”}

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

Are you otherwise able to create, access and interact with Local sites in your app aside from using your database tools?

Are you utilizing the Apple Silicon version on this machine?

Local itself works as expected, no issues.

Yes, I’m using the Silicon version of Local on this machine.

I’ve given all involved apps full-disk access but that changed nothing.

I’m looking through some older Forum threads on this @machouinard since I’m not familiar with using Navicat myself. Have you tried anything like this?

Thanks, Nick.

Yes, that’s screenshot #2 in my original post where the socket path is set.

Are you sure you’re using root as the password, @machouinard, and that the site is running?

I’m able to connect to Local’s database with Navicat on macOS using root as user and root as password.

The only way I was able to reproduce a 2002 error so far is if the site isn’t running in Local.

1 Like

Thanks @nickc

100% sure I’m using root/root. I’ve been using this setup for years without issue. The only difference is I’m now using a Mac Studio with an M2 Ultra. Everything I’ve seen before this morning smells like an issue with the Arm64 architecture.

The only difference I’m seeing when the Local site is running, is that the error message ends in (1) and when the site is not running the message ends in (2). This is the same with any site I create.



BUT… I found this post from 2020 explaining how to connect using IP instead of socket. I seem to be back in business but I’m still in the dark as to why this stopped working.

Thanks for confirming that and for sharing your workaround, @machouinard.

So far I can’t reproduce this on macOS under Apple Silicon. If you’re not using security software such as Little Snitch or Lulu that could block access, I’m not yet sure what could cause this.

Thanks, @nickc .

No security software in use. I appreciate you looking into it.

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.