错误描述
[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