Communication Protocols
MySQL supports different types of connections from the client to the server.
| Protocol | Type of connection | Supported operating systems |
|---|---|---|
| TCP\/IP | Local\/remote | All |
| Unix socket file | Local | Unix |
| Named pipes | Local | Windows |
| Shared memory | Local | Windows |
Disabling TCP\/IP
TCP\/IP can be disabled by using the start-up option passed to the mysqld command line --skip-networking.
TCP\/IP networking can also be disable in the my.cnf config file
[mysqld]
skip-networking
Named Pipes
Names pipes are disabled by default and can be enabled by using the --enable-named-pipe option
Shared Memory
Shared memory is disabled by default and can be enabled by using the startup option --shared-memory