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? Fee…

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…

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? [image] Connect to MySQL from Navicat Support OK, I managed to get Navicat working with Local. Here’s what I did. In Lo…

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. [navi…

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.

Connection through socket fails on Mac

Support

Nick-B June 1, 2024, 8:27pm 5

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?

Topic		Replies	Views
Local 5.2.4 : Can't connect to local MySQL server through socket (macOS) Support mac	16	5413	September 9, 2020
Wp db check not working Support	6	1295	September 14, 2020
Mysql socket Support	3	82	September 4, 2024
I can not connect to localwp database from DBeaver Support mac	5	812	June 11, 2024
Can't connect to local MySQL server through socket - Headless setup fails and removes all files WP Engine Headless Platform mac-mojave	4	2969	March 13, 2024

Connection through socket fails on Mac

Related topics