mysql -uroot -prootpass --skip-column-names -e 'select plugin_name, plugin_status, plugin_type, plugin_library, plugin_license from information_schema.all_plugins where plugin_name not in ('\''SPIDER'\'') order by plugin_name, plugin_library'
|
+-------------------------------+---------------+---------------------+--------------------------+-----+
|
| ARCHIVE | NOT INSTALLED | STORAGE ENGINE | ha_archive.so | GPL |
|
| Aria | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| BLACKHOLE | NOT INSTALLED | STORAGE ENGINE | ha_blackhole.so | GPL |
|
| CLIENT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| DISKS | NOT INSTALLED | INFORMATION SCHEMA | disks.so | GPL |
|
| ed25519 | NOT INSTALLED | AUTHENTICATION | auth_ed25519.so | GPL |
|
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federated.so | GPL |
|
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federatedx.so | GPL |
|
| FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL |
|
| file_key_management | NOT INSTALLED | ENCRYPTION | file_key_management.so | GPL |
|
| GEOMETRY_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| handlersocket | NOT INSTALLED | DAEMON | handlersocket.so | BSD |
|
| INDEX_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| inet6 | ACTIVE | DATA TYPE | NULL | GPL |
|
| inet6_aton | ACTIVE | FUNCTION | NULL | GPL |
|
| inet6_ntoa | ACTIVE | FUNCTION | NULL | GPL |
|
| inet_aton | ACTIVE | FUNCTION | NULL | GPL |
|
| inet_ntoa | ACTIVE | FUNCTION | NULL | GPL |
|
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_MUTEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_SEMAPHORE_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE | INFORMATION SCHEMA | NULL | BSD |
|
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| is_ipv4 | ACTIVE | FUNCTION | NULL | GPL |
|
| is_ipv4_compat | ACTIVE | FUNCTION | NULL | GPL |
|
| is_ipv4_mapped | ACTIVE | FUNCTION | NULL | GPL |
|
| is_ipv6 | ACTIVE | FUNCTION | NULL | GPL |
|
| LOCALES | NOT INSTALLED | INFORMATION SCHEMA | locales.so | BSD |
|
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| METADATA_LOCK_INFO | NOT INSTALLED | INFORMATION SCHEMA | metadata_lock_info.so | GPL |
|
| MRG_MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam.so | GPL |
|
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam_v1.so | GPL |
|
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| QUERY_CACHE_INFO | NOT INSTALLED | INFORMATION SCHEMA | query_cache_info.so | BSD |
|
| QUERY_RESPONSE_TIME | NOT INSTALLED | INFORMATION SCHEMA | query_response_time.so | GPL |
|
| QUERY_RESPONSE_TIME_AUDIT | NOT INSTALLED | AUDIT | query_response_time.so | GPL |
|
| SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| SERVER_AUDIT | NOT INSTALLED | AUDIT | server_audit.so | GPL |
|
| simple_password_check | NOT INSTALLED | PASSWORD VALIDATION | simple_password_check.so | GPL |
|
| SPATIAL_REF_SYS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| SPHINX | NOT INSTALLED | STORAGE ENGINE | ha_sphinx.so | GPL |
|
| SQL_ERROR_LOG | NOT INSTALLED | AUDIT | sql_errlog.so | GPL |
|
| SQL_SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| TABLE_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_GROUPS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_QUEUES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| unix_socket | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| USER_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| user_variables | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| wsrep | ACTIVE | REPLICATION | NULL | GPL |
|
| WSREP_MEMBERSHIP | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
|
| WSREP_STATUS | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
|
+-------------------------------+---------------+---------------------+--------------------------+-----+
|
|
cd /etc/mysql
|
mv my.cnf.dpkg-new my.cnf
|
systemctl restart mariadb
|
mysql -uroot -prootpass --skip-column-names -e 'select plugin_name, plugin_status, plugin_type, plugin_library, plugin_license from information_schema.all_plugins where plugin_name not in ('\''SPIDER'\'') order by plugin_name, plugin_library'
|
+-------------------------------+---------------+---------------------+--------------------------+-----+
|
| ARCHIVE | NOT INSTALLED | STORAGE ENGINE | ha_archive.so | GPL |
|
| Aria | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| BLACKHOLE | NOT INSTALLED | STORAGE ENGINE | ha_blackhole.so | GPL |
|
| CLIENT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| DISKS | NOT INSTALLED | INFORMATION SCHEMA | disks.so | GPL |
|
| ed25519 | NOT INSTALLED | AUTHENTICATION | auth_ed25519.so | GPL |
|
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federated.so | GPL |
|
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federatedx.so | GPL |
|
| FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL |
|
| file_key_management | NOT INSTALLED | ENCRYPTION | file_key_management.so | GPL |
|
| GEOMETRY_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| handlersocket | NOT INSTALLED | DAEMON | handlersocket.so | BSD |
|
| INDEX_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| inet6 | ACTIVE | DATA TYPE | NULL | GPL |
|
| inet6_aton | ACTIVE | FUNCTION | NULL | GPL |
|
| inet6_ntoa | ACTIVE | FUNCTION | NULL | GPL |
|
| inet_aton | ACTIVE | FUNCTION | NULL | GPL |
|
| inet_ntoa | ACTIVE | FUNCTION | NULL | GPL |
|
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_MUTEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_SEMAPHORE_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE | INFORMATION SCHEMA | NULL | BSD |
|
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| is_ipv4 | ACTIVE | FUNCTION | NULL | GPL |
|
| is_ipv4_compat | ACTIVE | FUNCTION | NULL | GPL |
|
| is_ipv4_mapped | ACTIVE | FUNCTION | NULL | GPL |
|
| is_ipv6 | ACTIVE | FUNCTION | NULL | GPL |
|
| LOCALES | NOT INSTALLED | INFORMATION SCHEMA | locales.so | BSD |
|
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| METADATA_LOCK_INFO | NOT INSTALLED | INFORMATION SCHEMA | metadata_lock_info.so | GPL |
|
| MRG_MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam.so | GPL |
|
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam_v1.so | GPL |
|
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| QUERY_CACHE_INFO | NOT INSTALLED | INFORMATION SCHEMA | query_cache_info.so | BSD |
|
| QUERY_RESPONSE_TIME | NOT INSTALLED | INFORMATION SCHEMA | query_response_time.so | GPL |
|
| QUERY_RESPONSE_TIME_AUDIT | NOT INSTALLED | AUDIT | query_response_time.so | GPL |
|
| SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| SERVER_AUDIT | NOT INSTALLED | AUDIT | server_audit.so | GPL |
|
| simple_password_check | NOT INSTALLED | PASSWORD VALIDATION | simple_password_check.so | GPL |
|
| SPATIAL_REF_SYS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| SPHINX | NOT INSTALLED | STORAGE ENGINE | ha_sphinx.so | GPL |
|
| SQL_ERROR_LOG | NOT INSTALLED | AUDIT | sql_errlog.so | GPL |
|
| SQL_SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| TABLE_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_GROUPS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_QUEUES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| THREAD_POOL_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| unix_socket | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| USER_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| user_variables | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| wsrep | ACTIVE | REPLICATION | NULL | GPL |
|
| WSREP_MEMBERSHIP | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
|
| WSREP_STATUS | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
|
+-------------------------------+---------------+---------------------+--------------------------+-----+
|
Just for clarity, this is how I was able to reproduce this and the intermediate steps involved:
# Start Ubuntu Bionic, default repos only
apt install mysql-common
find /etc/mysql -ls
256266 4 drwxr-xr-x 3 root root 4096 May 19 15:05 /etc/mysql
256330 4 drwxr-xr-x 2 root root 4096 May 19 15:05 /etc/mysql/conf.d
256332 4 -rw-r--r-- 1 root root 55 Aug 3 2016 /etc/mysql/conf.d/mysqldump.cnf
256331 4 -rw-r--r-- 1 root root 8 Aug 3 2016 /etc/mysql/conf.d/mysql.cnf
256046 0 lrwxrwxrwx 1 root root 24 May 19 15:05 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf
256333 4 -rw-r--r-- 1 root root 839 Aug 3 2016 /etc/mysql/my.cnf.fallback
# Enable mariadb.org repository
apt install mariadb-server # does not pull in mysql-common
find /etc/mysql -ls
256266 4 drwxr-xr-x 4 root root 4096 May 19 15:06 /etc/mysql
256330 4 drwxr-xr-x 2 root root 4096 May 19 15:06 /etc/mysql/conf.d
281171 4 -rw-r--r-- 1 root root 36 May 11 14:34 /etc/mysql/conf.d/mysqld_safe_syslog.cnf
256332 4 -rw-r--r-- 1 root root 55 Aug 3 2016 /etc/mysql/conf.d/mysqldump.cnf
256331 4 -rw-r--r-- 1 root root 8 Aug 3 2016 /etc/mysql/conf.d/mysql.cnf
256046 0 lrwxrwxrwx 1 root root 24 May 19 15:05 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf
281437 4 -rwxr-xr-x 1 root root 1620 May 11 14:34 /etc/mysql/debian-start
256333 4 -rw-r--r-- 1 root root 839 Aug 3 2016 /etc/mysql/my.cnf.fallback
281479 4 -rw------- 1 root root 60 May 19 15:06 /etc/mysql/debian.cnf
256350 4 -rw-r--r-- 1 root root 527 May 11 14:34 /etc/mysql/mariadb.cnf
256351 4 drwxr-xr-x 2 root root 4096 May 11 14:37 /etc/mysql/mariadb.conf.d
apt install mysql-common # does not overwrite /etc/my.cnf
find /etc/mysql -ls
256266 4 drwxr-xr-x 4 root root 4096 May 19 15:07 /etc/mysql
256330 4 drwxr-xr-x 2 root root 4096 May 19 15:06 /etc/mysql/conf.d
281171 4 -rw-r--r-- 1 root root 36 May 11 14:34 /etc/mysql/conf.d/mysqld_safe_syslog.cnf
256332 4 -rw-r--r-- 1 root root 55 Aug 3 2016 /etc/mysql/conf.d/mysqldump.cnf
256331 4 -rw-r--r-- 1 root root 8 Aug 3 2016 /etc/mysql/conf.d/mysql.cnf
281565 8 -rw-r--r-- 1 root root 5170 May 11 14:34 /etc/mysql/my.cnf.dpkg-new
256046 0 lrwxrwxrwx 1 root root 24 May 19 15:05 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf
281437 4 -rwxr-xr-x 1 root root 1620 May 11 14:34 /etc/mysql/debian-start
256333 4 -rw-r--r-- 1 root root 839 Aug 3 2016 /etc/mysql/my.cnf.fallback
281479 4 -rw------- 1 root root 60 May 19 15:06 /etc/mysql/debian.cnf
256350 4 -rw-r--r-- 1 root root 527 May 11 14:34 /etc/mysql/mariadb.cnf
256351 4 drwxr-xr-x 2 root root 4096 May 11 14:37 /etc/mysql/mariadb.conf.d
So our `my.cnf` ends up in `/etc/mysql/my.cnf.dpkg-new` and thus my.cnf stays wrong and does not load MariaDB parts.
Result:
mysql -uroot -prootpass --skip-column-names -e 'select plugin_name, plugin_status, plugin_type, plugin_library, plugin_license from information_schema.all_plugins where plugin_name not in ('\''SPIDER'\'') order by plugin_name, plugin_library'
+-------------------------------+---------------+---------------------+--------------------------+-----+
| ARCHIVE | NOT INSTALLED | STORAGE ENGINE | ha_archive.so | GPL |
| Aria | ACTIVE | STORAGE ENGINE | NULL | GPL |
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | NOT INSTALLED | STORAGE ENGINE | ha_blackhole.so | GPL |
| CLIENT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| DISKS | NOT INSTALLED | INFORMATION SCHEMA | disks.so | GPL |
| ed25519 | NOT INSTALLED | AUTHENTICATION | auth_ed25519.so | GPL |
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federated.so | GPL |
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federatedx.so | GPL |
| FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL |
| file_key_management | NOT INSTALLED | ENCRYPTION | file_key_management.so | GPL |
| GEOMETRY_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| handlersocket | NOT INSTALLED | DAEMON | handlersocket.so | BSD |
| INDEX_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| inet6 | ACTIVE | DATA TYPE | NULL | GPL |
| inet6_aton | ACTIVE | FUNCTION | NULL | GPL |
| inet6_ntoa | ACTIVE | FUNCTION | NULL | GPL |
| inet_aton | ACTIVE | FUNCTION | NULL | GPL |
| inet_ntoa | ACTIVE | FUNCTION | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_MUTEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_SEMAPHORE_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE | INFORMATION SCHEMA | NULL | BSD |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| is_ipv4 | ACTIVE | FUNCTION | NULL | GPL |
| is_ipv4_compat | ACTIVE | FUNCTION | NULL | GPL |
| is_ipv4_mapped | ACTIVE | FUNCTION | NULL | GPL |
| is_ipv6 | ACTIVE | FUNCTION | NULL | GPL |
| LOCALES | NOT INSTALLED | INFORMATION SCHEMA | locales.so | BSD |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| METADATA_LOCK_INFO | NOT INSTALLED | INFORMATION SCHEMA | metadata_lock_info.so | GPL |
| MRG_MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam.so | GPL |
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam_v1.so | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| QUERY_CACHE_INFO | NOT INSTALLED | INFORMATION SCHEMA | query_cache_info.so | BSD |
| QUERY_RESPONSE_TIME | NOT INSTALLED | INFORMATION SCHEMA | query_response_time.so | GPL |
| QUERY_RESPONSE_TIME_AUDIT | NOT INSTALLED | AUDIT | query_response_time.so | GPL |
| SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| SERVER_AUDIT | NOT INSTALLED | AUDIT | server_audit.so | GPL |
| simple_password_check | NOT INSTALLED | PASSWORD VALIDATION | simple_password_check.so | GPL |
| SPATIAL_REF_SYS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| SPHINX | NOT INSTALLED | STORAGE ENGINE | ha_sphinx.so | GPL |
| SQL_ERROR_LOG | NOT INSTALLED | AUDIT | sql_errlog.so | GPL |
| SQL_SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| TABLE_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_GROUPS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_QUEUES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| unix_socket | ACTIVE | AUTHENTICATION | NULL | GPL |
| USER_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| user_variables | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| wsrep | ACTIVE | REPLICATION | NULL | GPL |
| WSREP_MEMBERSHIP | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
| WSREP_STATUS | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
+-------------------------------+---------------+---------------------+--------------------------+-----+
cd /etc/mysql
mv my.cnf.dpkg-new my.cnf
systemctl restart mariadb
mysql -uroot -prootpass --skip-column-names -e 'select plugin_name, plugin_status, plugin_type, plugin_library, plugin_license from information_schema.all_plugins where plugin_name not in ('\''SPIDER'\'') order by plugin_name, plugin_library'
+-------------------------------+---------------+---------------------+--------------------------+-----+
| ARCHIVE | NOT INSTALLED | STORAGE ENGINE | ha_archive.so | GPL |
| Aria | ACTIVE | STORAGE ENGINE | NULL | GPL |
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| BLACKHOLE | NOT INSTALLED | STORAGE ENGINE | ha_blackhole.so | GPL |
| CLIENT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| DISKS | NOT INSTALLED | INFORMATION SCHEMA | disks.so | GPL |
| ed25519 | NOT INSTALLED | AUTHENTICATION | auth_ed25519.so | GPL |
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federated.so | GPL |
| FEDERATED | NOT INSTALLED | STORAGE ENGINE | ha_federatedx.so | GPL |
| FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL |
| file_key_management | NOT INSTALLED | ENCRYPTION | file_key_management.so | GPL |
| GEOMETRY_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| handlersocket | NOT INSTALLED | DAEMON | handlersocket.so | BSD |
| INDEX_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| inet6 | ACTIVE | DATA TYPE | NULL | GPL |
| inet6_aton | ACTIVE | FUNCTION | NULL | GPL |
| inet6_ntoa | ACTIVE | FUNCTION | NULL | GPL |
| inet_aton | ACTIVE | FUNCTION | NULL | GPL |
| inet_ntoa | ACTIVE | FUNCTION | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_MUTEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_SEMAPHORE_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_SYS_VIRTUAL | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE | INFORMATION SCHEMA | NULL | BSD |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| is_ipv4 | ACTIVE | FUNCTION | NULL | GPL |
| is_ipv4_compat | ACTIVE | FUNCTION | NULL | GPL |
| is_ipv4_mapped | ACTIVE | FUNCTION | NULL | GPL |
| is_ipv6 | ACTIVE | FUNCTION | NULL | GPL |
| LOCALES | NOT INSTALLED | INFORMATION SCHEMA | locales.so | BSD |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| METADATA_LOCK_INFO | NOT INSTALLED | INFORMATION SCHEMA | metadata_lock_info.so | GPL |
| MRG_MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam.so | GPL |
| pam | NOT INSTALLED | AUTHENTICATION | auth_pam_v1.so | GPL |
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL |
| QUERY_CACHE_INFO | NOT INSTALLED | INFORMATION SCHEMA | query_cache_info.so | BSD |
| QUERY_RESPONSE_TIME | NOT INSTALLED | INFORMATION SCHEMA | query_response_time.so | GPL |
| QUERY_RESPONSE_TIME_AUDIT | NOT INSTALLED | AUDIT | query_response_time.so | GPL |
| SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| SERVER_AUDIT | NOT INSTALLED | AUDIT | server_audit.so | GPL |
| simple_password_check | NOT INSTALLED | PASSWORD VALIDATION | simple_password_check.so | GPL |
| SPATIAL_REF_SYS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| SPHINX | NOT INSTALLED | STORAGE ENGINE | ha_sphinx.so | GPL |
| SQL_ERROR_LOG | NOT INSTALLED | AUDIT | sql_errlog.so | GPL |
| SQL_SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
| TABLE_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_GROUPS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_QUEUES | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| THREAD_POOL_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| unix_socket | ACTIVE | AUTHENTICATION | NULL | GPL |
| USER_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| user_variables | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
| wsrep | ACTIVE | REPLICATION | NULL | GPL |
| WSREP_MEMBERSHIP | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
| WSREP_STATUS | NOT INSTALLED | INFORMATION SCHEMA | wsrep_info.so | GPL |
+-------------------------------+---------------+---------------------+--------------------------+-----+