How can I disable mysql_native_password and mysql_old_password on MariaDB / MySQL? I only want to use unix_socket as the sole authentication method.
Both mysql_native_password and mysql_old_password are installed and enabled by default, but I'd like to disable them.
I'm unable to uninstall them:
MariaDB [(none)]&gt; uninstall plugin mysql_native_password;
ERROR 1619 (HY000): Built-in plugins cannot be deleted            

I've followed the instructions here:
https://mariadb.com/kb/en/mysql_plugin/
I've created disabled_plugins.ini in /etc/mysql with contents:
disabled_plugins
mysql_old_password

Then:
MariaDB [(none)]&gt; mysql_plugin disabled_plugins DISABLE;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql_plugin disabled_plugins DISABLE' at line 1

This is on WSL1 and 10.3.27-MariaDB-0+deb10u1-log Debian 10
Can someone help?
Thanks
You are suppose to run this command from server command line not from MariaDB console.
mysql_plugin disabled_plugins DISABLE
And then login to MariaDB &amp; check :
 SELECT * FROM mysql.plugin;