MySQL 8 Administrator???s Guide

Socket peer-credential pluggable authentication

The server-side plugin named auth_socket is used to authenticate clients which are connected from the local host using the Unix socket file. It is only used for a system that supports the SO_PEERCRED option. SO_PEERCRED is used to obtain information about the user running the client program. This is not a built-in plugin; we must use the auth_socket.so library with this plugin. To make it usable, put the library file under the plugin directory first, and then perform either of these steps:

1. Load the plugin on server startup by adding the --plugin-load-add parameter in the my.cnf file:

        [mysqld]        plugin-load-add=auth_socket.so

2. Register the plugin at runtime by executing the following command: ...