simon551 Posted August 14, 2009 Share Posted August 14, 2009 I created a new xampp installation today and went in and changed the password for the root user at localhost. Now I am locked out of phpmyadmin altogether. I get this message: Error MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. It's not prompting me to login. I'm not sure what I did wrong but I must have messed up somewhere. Any idea? Link to comment https://forums.phpfreaks.com/topic/170322-solved-xamppphpmyadmin-security-problem/ Share on other sites More sharing options...
trq Posted August 14, 2009 Share Posted August 14, 2009 Haven't used phpmyadmin for a long time but theres a config.php file somewhere that stores the username / password that phpmyadmin uses to connect to mysql. Link to comment https://forums.phpfreaks.com/topic/170322-solved-xamppphpmyadmin-security-problem/#findComment-898476 Share on other sites More sharing options...
wildteen88 Posted August 14, 2009 Share Posted August 14, 2009 Rather than hard code the username/password within config.inc.php change this line within config.inc.php $cfg['Servers'][$i]['auth_type'] = 'config'; To $cfg['Servers'][$i]['auth_type'] = 'http'; This time phpMyAdmin will prompt you to provide a username/password. This is much more secure. Link to comment https://forums.phpfreaks.com/topic/170322-solved-xamppphpmyadmin-security-problem/#findComment-898480 Share on other sites More sharing options...
simon551 Posted August 14, 2009 Author Share Posted August 14, 2009 Got it. Thanks. phpmyadmin/config.inc.php I don't use it either except for setting up security. I use navicat for my database needs. you? Link to comment https://forums.phpfreaks.com/topic/170322-solved-xamppphpmyadmin-security-problem/#findComment-898482 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.