ERROR 1045 (28000): Access denied for user 'root'@'localhost'解决办法

新安装MariaDB无法登入(Access denied)

错误提示：ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’
报错环境：CentOS8
解决方案：
第一步：关闭MariaDB服务

systemctl stop mariadb

第二步：后台使用mysqld_safe命令在参数skip-grant-tables下启动数据库

nohup mysqld_safe --skip-grant-tables >/dev/null 2>&1 &

第三步：修改root@localhost用户密码

mysql -u root
use mysql;
update user set password=PASSWORD("passwd") where User = 'root';
\q;

第四步：关闭mysql所有进程后正常启动(在–skip-grant-tables参数下无法执行mysql -e "command"故需要重启mysql)

ps -a |grep mysql|xargs kill -9 2>/dev/null
systemctl start mariadb

完整shell脚本如下

#!/bin/bash
nohup mysqld_safe --skip-grant-tables >/dev/null 2>&1 &
mysql<<EOF
use mysql;
update user set password=PASSWORD("passwd") where User = 'root';
\q;
EOF
ps -a |grep mysql|xargs kill -9 2>/dev/null
systemctl start mariadb