Comments - Access denied for user 'root'@'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.
Newer Debian versions use the UNIX socket authentication for the root user. In MariaDB, the
localhostaddress is actually referring to the local UNIX domain socket (usually at/var/lib/mysql/mysql.sock) that the server listens on and is separate from the address defined by bind_address.If possible, creating a completely new user guarantees that no default configurations are in use. Modifying the
mysql.usertable shouldn't be done as it might not actually reflect what the server actually holds in memory.It turned out that the issue was that I was accessing Adminer over http, not https. Enabling https in my Apache config solved the issue.