安装好数据库 初始化时报错 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决步骤如下:
1. 首先停掉数据库服务: systemctl stop mariadb.service
2. 使用mysqld_safe来启动mysqld服务器 : mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
显示: 退出Ctrl+c
3 . 登录 : mysql -u root mysql
4 . 修改root用户密码: UPDATE user SET PASSWORD=PASSWORD('newpassword') where USER='root';
5 . 使用修改后的root用户和新密码newpassword登录数据库: mysql -uroot -p
The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement
创建用户时报错,执行语句为:
GRANT ALL PRIVILEGES ON *.* TO helei IDENTIFIED BY 'MANAGER' WITH GRANT OPTION;
解决:mysql> flush privileges;