Jump to content

Error #1045 - Access denied for user 'root'@'localhost' (using password: NO)


Cat

Recommended Posts

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

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.