mariadb 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[root@localhost /]# systemctl stop mariadb.service
[root@localhost /]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 46043
[root@localhost /]# 150131 03:15:27 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
150131 03:15:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysql -u root mysql

MariaDB [mysql]> UPDATE user SET Password=PASSWORD('123123') where USER='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 3 Changed: 1 Warnings: 0

MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> quit
Bye

[root@localhost /]# systemctl start mariadb.service
[root@localhost /]#

时间: 2025-01-20 09:45:23

mariadb 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)的相关文章

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) root@mysql ~]# mysql -p -u root Enter password:  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ERROR 1045 (28000): Access denied

解决mariadb grant ERROR 1045 (28000): Access denied for user

用mariadb也有一段时间了,常用命令和语法,基本没变.比较复杂一点的,例如replication,也没有发现根mysql有什么不同的地方. 不过,今天真发现有不同的地方了,mariadb的权限管理根mysql不一样,mysql可以创建一个根root账户同等权限的账户,但是mariadb就不行了,写法上也所不同. 1,mariadb  grant授权报错    MariaDB [(none)]> grant all privileges on *.* TO tank@'192.168.%' I

mysql全局权限账户%登录不上ERROR 1045 (28000): Access denied for user 'mhz'@'localhost' (using password: YES)

mysql全局权限账户%登录不上 ERROR 1045 (28000): Access denied for user 'mhz'@'localhost' (using password: YES)  解决 查看错误提示  有主机名字的就必须赋值主机名 mysql> GRANT ALL PRIVILEGES ON *.* TO 'mhz'@'mgr2' IDENTIFIED BY 'mhz' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 s

ERROR 1045 (28000): Access denied for user 'axt'@'localhost' (using pass

ERROR 1045 (28000): Access denied for user 'axt'@'localhost' (using password: YES)解决 环境:MySQL Sever 5.1 + MySQL命令行工具 问题:MySQL用户远程登录遇到此问题:ERROR 1045 (28000): Access denied for user 'axt'@'localhost' (usingpassword: YES). 如图: 解决: 新创建的用户不能立即失效,执行以下命令后重启

MySQL中出现连接错误:ERROR 1045 (28000): Access denied for user

  MySQL中出现连接错误: ERROR 1045 (28000): Access denied for user ---------------------------------------------------------------------------------- 1.添加用户 shell>mysql mysql>use mysql mysql>grant all privileges on *.* to 'test' identified by 'test' with

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

风信网(ithov.com)原创文章:今天在测试一款bacula开源备份软件的时候,需要使用到mysql数据库,当运行以下命令时报错误如下: [root@localhost etc]# ./grant_mysql_privileges ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Error creating privileges. 登陆到msyql中去解决该问题: [root

MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)的真正原因

在博客Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)里 面,我介绍了一下安装MySQL后登陆MySQL时会遇到ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 这个错误,当时不知道真正的原因,搜索了一些网上的资料,测试验证了如何解决

Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

案例环境:              操作系统 :Red Hat Enterprise Linux Server release 5.7 (Tikanga) 64 bit           数据库版本 : Mysql 5.6.19 64 bit 案例介绍: 今 天开始学习mysql,遂先安装了Mysql 5.6.19 64bit 版本的数据库,结果安装成功了,但是使用root登录时遇到了ERROR 1045 (28000): Access denied for user 'root'@'loc

【技术贴】解决Mysql ERROR 1045 (28000): Access denied for

  今天Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' 肯定是密码不对了.那么重置一下密码吧.   打开 cmd 输入以下四个步骤:   1.mysql -u root mysql (登陆mysql.如果你没有在环境变量path里面加入bin路径,建议你直接去mysql的bin目录下运行此命令) 2. UPDATE user SET Password=PASSWORD('123456') where USER