☰

错误：mysqld：插件‘unix_socket’已安装

tag-icon • tag-icon mysql mariadb
错误：mysqld：插件‘unix_socket’已安装

每次重新启动 mysql（mariadb）时都会出现此错误：

[ERROR] mysqld: Plugin 'unix_socket' already installed
[Note] Server socket created on IP: '::'.

但我甚至没有尝试启用或设置这个 unix_socket

[注意]mysqld（mysqld 10.1.47-MariaDB-0+deb9u1）

答案1

从 mysql.plugin 表中删除 unix_socket 记录

select * from mysql.plugin;
+--------------+-----------------+
| name         | dl              |
+--------------+-----------------+
| SERVER_AUDIT | server_audit.so |
| pam          | auth_pam.so     |
| unix_socket  | auth_socket.so  |
+--------------+-----------------+
delete from mysql.plugin where name='unix_socket';

相关内容