Cat Posted August 14, 2007 Share Posted August 14, 2007 I see this error in my nightmares I have installed PHP 5.2.3, MySQL 5.0.37 and have verified both are running fine - first through printing out the php info to the screen and through running the MySQL command line client -> logging in with the password I gave during the configuration and getting the "Welcome to the MySQL monitor" message. I have unzipped PHPMyAdmin into my root directory - in my case wwwroot since I'm running IIS7. My config.inc.php file is in the phpmyadmin directory and this is what it says <?php /* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */ // vim: expandtab sw=4 ts=4 sts=4: /** * phpMyAdmin sample configuration, you can use it as base for * manual configuration. For easier setup you can use scripts/setup.php * * All directives are explained in Documentation.html and on phpMyAdmin * wiki <http://wiki.cihar.com>. */ /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'blahblahblah'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['PmaAbsoluteUri'] = '/localhost/phpMyAdmin/'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'password'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; /* User for advanced features */ // $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass'; /* Advanced phpMyAdmin features */ // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // $cfg['Servers'][$i]['relation'] = 'pma_relation'; // $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // $cfg['Servers'][$i]['history'] = 'pma_history'; // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; /* * End of servers configuration */ /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?> I have left much of the file commented out so things are less complicated. If I use this configuration when I try to log in at the PHPMyAdmin index page I get the error you see in the subject line... if I change the auth_type to config and comment out the blowfish_secret I get the same error but instead of being above the two sign in fields the page reloads and it only has the error, the same one but with a preamble claiming that when it tried to connect the the MySQL server the password or username was rejected by the server ( the password I'm using is not "password" I've just used that in the quote). The username I am attempting to log in with is root and the password is the same one I use to log on to the MySQL command line client. The OS I'm using is Vista Home Premium. If anyone has any idea why this is going as badly as it is please let me know, thanks Cat Quote Link to comment https://forums.phpfreaks.com/topic/64796-error-1045-access-denied-for-user-rootlocalhost-using-password-no/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.