Always works fine on my campus, its a local network program, doesn't require external access.
However, is there a way of connecting to a MySQL database without using a TCP/IP port configuration. If I ever need to distribute this software to another site, I may not always be able to get firewall rules changed to allow 3306 through.
protocol Value | Connection Protocol | Permissible Operating Systems
TCP | TCP/IP connection to local or remote server | All
SOCKET | Unix socket file connection to local server | Unix only
PIPE | Named-pipe connection to local or remote server | Windows only
MEMORY | Shared-memory connection to local server | Windows only
As you can see, there are other options to connect to a mysql server, but the other methods are either platform specific or cannot be used to access remote servers. Obviously, you can also tunnel the mysql connection through another port. You can use tunneling on both the client and the server side. This latter one is purely a sysadmin / DBA question, so for details I would rather ask on the dba or serverfault sister sites.
Asked in February 2016Viewed 1,171 timesVoted 5Answered 1 times