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
- Create new connection in Navicat.
- Set host, port, username, and password on General Tab.
- On Advanced tab, check “Use socket file” and paste socket path from Local.
- 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.
