Troubleshooting MariaDB 'Access denied for user root@localhost'

While connecting to a local MariaDB installation from Ubuntu, I encountered the following error:

Access denied for user 'root'@'localhost'

In this particular installation, the database root account was configured to authenticate through the local operating-system context. Running the client with elevated privileges allowed the connection to succeed:

Why This Can Happen

MariaDB and MySQL installations can use different authentication plugins and account configurations. On some Linux distributions, the database root account may be configured for socket-based authentication rather than conventional password authentication. In that configuration, simply supplying a database password is not equivalent to connecting as the appropriate operating-system user.

Important: Do not assume that every MariaDB root account has no password, and do not use sudo as a universal fix for authentication failures. Inspect the authentication configuration for the specific server before changing credentials or privileges.

Safer Troubleshooting Approach

When this error appears, first determine how the root@localhost account is configured. Check the server version, authentication plugin, account privileges, and distribution-specific installation behavior. Use elevated operating-system privileges only when the server's documented local-administration model requires them.

Takeaway

The error in this environment was caused by the local authentication model rather than an incorrect SQL statement. Database access problems should be diagnosed by understanding the configured authentication mechanism instead of assuming a default password or weakening the account configuration.