PhpMyAdmin密码 [英] PhpMyAdmin password

查看:105
本文介绍了PhpMyAdmin密码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我收到错误#1045-用户'root'@'localhost'的访问被拒绝(使用密码:NO) 在我无意中更改了root和127.0.0.1的phpmyadmin中的密码后.问题是我无法更改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.

这篇关于PhpMyAdmin密码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆