Access Database with Port Rather Than Socket Externally

I know that we can use the Socket to access the Local databases in external apps such as TablePlus. But socket connections are not supported with all SQL apps, particularly the increasing number that are sandboxed on macOS. The sites.json file lists ports for mysql for each site. Yet when I try to connect with these in external apps (I’ve tested with SQL Pro Studio) using hosts such as 127.0.0.1:xxxxx the connections fail even if the app sees the server as online. Is there some way that we can access local databases via port rather than socket if an app simply has no socket support?

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