PhpMyAdmin 密码

2022-01-05 00:00:00 mysql phpmyadmin mysql-error-1045

我收到错误 #1045 - 用户 'root'@'localhost' 访问被拒绝(使用密码:NO)在我不小心更改了 phpmyadmin 中 root 和 127.0.0.1 的密码之后.问题是我无法更改 common.lib.php.我想以某种方式恢复 mysql 中的这些更改......服务器的安全性我不能改变太多

I get the error #1045 - Access denied for user 'root'@'localhost' (using password: NO) after I accidentaly changed the password in phpmyadmin for root and 127.0.0.1 . the problem is i cannot change common.lib.php. I want to revert these changes in mysql somehow... Doe to the security of the server i cannot change much

推荐答案

我已经有一段时间没有使用 phpMyAdmin，但如果我没记错的话，它会自行将密码存储在 mysql 数据库中.因此，如果您能够访问服务器的命令行，您可以使用简单的 SQL 语句更改密码.

It's been a while since I've used phpMyAdmin, but if I'm not mistaken, it stores it's passwords in the mysql database it self. So, if you are able to get access to the command-line of the server, you are able to change the password using simple SQL statements.

相关文章