mariadb Access denied for user ‘root‘@‘localhost‘

错误描述

[error] failed to initialize database, got error Error 1698: Access denied for user 'root'@'localhost'
2022/09/02 08:49:01 Error 1698: Access denied for user 'root'@'localhost'
panic: 数据库链接失败

问题解决

1、清空root用户的密码

sudo mysql -u root

use mysql;

update user set plugin='' where User='root';

flush privileges; 

exit;

2、设置全局密码

sudo mysql -u root

---设置密码登录

grant all privileges on *.* to 'root'@'%' identified by 'mysql_native_password with grant option;

或者运行mysql：

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket'; 

flush privileges;

exit;

需要重新启动 mysql/mariadb：

sudo service mysql restart