【已解决】数据库管理密码错误

新建数据库，和备份，都一直提示：数据库管理密码错误，这个怎么处理呢？

[quote][size=2][url=forum.php?mod=redirect&goto=findpost&pid=392298&ptid=95825][color=#999999]1043829116 发表于 2022-7-9 22:05[/color][/url][/size]
重置了，服务器也重启了，还是不行。 照样：数据库管理密码错误！
怎么搞呢？ ...[/quote]

如果phpmyadmin也登录不了的话，试试这个方法
[code]mysql的root@localhost账户丢失，恢复步骤
mysql> use mysql;
Database changed

mysql> insert into user set user='root',ssl_cipher='',x509_issuer='',x509_subject='';
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'passwd' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

passwd是初始的密码[/code]

堡塔安全木兰 发表于 2022-7-9 21:24
数据库页面--重置一下mysql的root密码就可以了

重置了，服务器也重启了，还是不行。 照样：数据库管理密码错误！
怎么搞呢？

堡塔安全木兰 发表于 2022-7-9 22:35
如果phpmyadmin也登录不了的话，试试这个方法

按你这方法弄了，还是不行呀。接下来怎么整？

堡塔安全木兰 发表于 2022-7-9 23:05
将命令执行结果截图上传附件给我看看

[root@VM-0-5-centos ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 58
Server version: 5.6.50-log Source distribution

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'
mysql> insert into user set user='root',ssl_cipher='',x509_issuer='',x509_subject='';
ERROR 1046 (3D000): No database selected
mysql> flush privileges;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'F65pMaahFrWMwGr4' with grant option;
ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO)
mysql> flush privileges;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privilege(s) for this operation
mysql>

堡塔安全木兰 发表于 2022-7-10 00:04

按你此方法已经处理好，谢谢！辛苦了。

堡塔安全木兰 发表于 2022-7-10 00:04

按你这方法，已经处理好，谢谢了。

1043829116 发表于 2022-7-10 00:28
按你这方法，已经处理好，谢谢了。

你好 我按照你的方法添加数据库成功了，但是导入备份的数据库时 还出现 数据库管理密码错误是什么情况？

同样的问题，方法有效，已经处理好，谢谢了。宝塔的工作人员辛苦了