How to connect to db with .sock?

Support
1

What issue or error are you experiencing?

Not able to connect to db with different db client such as dbeaver

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

I am new with LocalWP.
Currently I have downloaded the LocalWP and created a new wordpress from it locally.
I want to use a dbeaver to access the database, which I’m used to access database with hostname + port and username / password but instead LocalWP is using Socket so I am having something like Library/Application Support/Local/run/Uwj5x-El7/mysql/mysqld.sock which I’m not sure how to connect to DB using another db software.

Screenshot 2025-02-24 at 3.10.45 PM
Screenshot 2025-02-24 at 3.10.45 PM1920×1594 104 KB

Wonder if someone can shade me some lights on how I can get this connected?

System Details

  • Local Version:

Version 9.2.2+6771

  • Operating System (OS) and OS version:

MacOS Sequoia Version 15.2

Local Logs

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

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.

2

Welcome, @et4891!

It looks like dbeaver doesn’t support socket connections. Someone posted a workaround here but I haven’t tested this with Local:

Also worth checking this thread:

If that doesn’t help you could try an alternative MySQL GUI with socket support, such as TablePlus.

1 Like
3

This post How can I connect to MySQL using TCP/IP rather than a socket on macOS/Linux?

Following the two steps in that post as workaround seem to work fine :clap:

2 Likes