Error Reported During MariaDB User Authentication

Symptom

An error message similar to "ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES)" is displayed during MariaDB user authentication.

Key Process and Cause Analysis

The default plugin attribute is incorrect.

Conclusion and Solution

Run the following commands to modify the plugin attribute:

update user set authentication_string=PASSWORD(''), plugin='mysql_native_password' where user='root';

flush privileges;