Mariadb MySQL enable socket_auth and disable unix_socket
to diable unix_socket auth (passwordless login on cli) Mariadb config /etc/mysql/mariadb.conf.d/50-server.cnf MySQL config /etc/mysql/my.cnf add following parameter <code> plugin-load-add = auth_socket.so </code> on mysql cli <code> update mysql.user set password=password(‘YOURPASSWORD’) …