Home  >  Article  >  Backend Development  >  phpmyadmin的#1045 - Access denied for user 'root'@'localhost' (using password: NO,该如何解决

phpmyadmin的#1045 - Access denied for user 'root'@'localhost' (using password: NO,该如何解决

WBOY
WBOYOriginal
2016-06-13 13:14:02929browse

phpmyadmin的#1045 - Access denied for user 'root'@'localhost' (using password: NO
在windows下面安装的php mysql 和phpmyadmin
在地址栏输入http://127.0.0.1/phpMyAdmin/或者http://127.0.0.1/phpMyAdmin/index.php时出现如下错误

“#1045 - Access denied for user 'root'@'localhost' (using password: NO) ”
版本是phpMyAdmin 2.11.6
已经在config.inc.php和config.sample.inc.php文件中修改了下面的代码

$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '我的密码';

但问题还是出现?

------解决方案--------------------
我也曾经出现这个问题。
这个问题要么就是密码不对要么就是你连接数据库的那个数据库主机错误即是那个$db_host的值错误
------解决方案--------------------
给数据库设个用户名密码,并且给此用户开放权限 这样才能访问上去
------解决方案--------------------
尝试在命令行下执行连接,以确认密码的正确性

按提示 #1045 - Access denied for user 'root'@'localhost' (using password: NO)
表示连接时没有输入口令
------解决方案--------------------
查看一下数据DB表和User表的设置
------解决方案--------------------
看一下这个地址对你有帮助 !~~

http://hi.baidu.com/panliangmei/blog/item/e36966fd5123f640d6887da9.html

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn