I can understand that the webserver and the database server are not always on the same computer but why does mysql/mariadb want to default to unix_socket instead of password authentication?
From my own experience, I’ve had to change the root account for database to password based authentication even when testing openemr on a lamp setup server.