Mariadb/MYSQL change plugin auth_socket to mysql_native_password

 

MariaDB [(none)]> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

MariaDB [mysql]> update user set plugin='mysql_native_password' where user='root';

Query OK, 1 row affected (0.001 sec)

Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [mysql]> flush privileges;

Query OK, 0 rows affected (0.002 sec)

MariaDB [mysql]>