Comments - mysql_install_db

3 years, 8 months ago Basil Hendroff

There's information for reverting to the previous authentication method at https://mariadb.com/kb/en/authentication-from-mariadb-104/. What I can't seem to readily locate is information on going the other way i.e. changing from the previous authentication method to using the unix_socket authentication method. For instance, when upgrading from MariaDB 10.3, the mysql_native_password method is still in effect. I would like to switch this off. This command seems to work:

ALTER USER root@localhost IDENTIFIED VIA unix_socket;

, However, based on the default accounts described above in this topic, are there accounts to clean up (from 10.3) or add (in 10.4 e.g mysql@localhost)?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.