mariadb 初始化时报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

安装好数据库初始化时报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

解决步骤如下:

1. 首先停掉数据库服务: systemctl stop mariadb.service

mariadb 初始化时报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

2. 使用mysqld_safe来启动mysqld服务器 : mysqld_safe --user=mysql --skip-grant-tables --skip-networking &

显示：退出Ctrl+c

mariadb 初始化时报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

3 . 登录 : mysql -u root mysql

mariadb 初始化时报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

4 . 修改root用户密码: UPDATE user SET PASSWORD=PASSWORD('newpassword') where USER='root';

5 . 使用修改后的root用户和新密码newpassword登录数据库: mysql -uroot -p