Error Reported When the MariaDB Is Created

Symptom

The MariaDB user authentication is normal, but an error message similar to "ERROR 1045 (28000): Access denied for user 'pasa'@'localhost' (using password: YES)" is displayed when the database is created.

Key Process and Cause Analysis

The permission of the pasa user is incorrect.

Conclusion and Solution

mysql -upasa -p123456

use mysql;

insert into mysql.user(Host,User,Password) values("localhost","pasa",password("123456"));