Home / server / Questions / 361681
Accepted
Eugene Yarmash
Asked: 2012-02-20 12:57:33 +0800 CST

How can I determine the connection method used by a MySQL client?

  • 772

When using a MySQL client (e.g. mysql or phpmyadmin) how can I determine whether it connected to the server using a Unix socket file or by using TCP/IP?

mysql

1 Answers

  1. Best Answer
    • mysql client: use the \s (or status) command. The output would have a line like one of the following: 
    Connection:             Localhost via UNIX socket
    • phpmyadmin: on the "Home" page search for Server:, e.g.

    Server: Localhost (Localhost via UNIX socket)

    netstat and sockstat (in FreeBSD) can be used to obtain this information in shell.

    • 0