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

warning: Parameter 1 to drigg_link() expected to be a reference, value given in /home/suro/public_html/diggit/includes/module.inc on line 406.

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

http://drupal.org –

Getting phpMyAdmin 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.

I am using book 'Drupal 7' Tom Geller.
I installed
WampServer 2.1a [24/12/10]
Includes :
- Apache 2.2.17
- Php 5.3.3
- Mysql 5.5.8 (version 32 bits)
- PhpMyadmin 3.2.0.1
- SQLBuddy 1.3.2

Everything was working ok when there were no passwords.
Yesterday as per pg 16 I added a database and gave it a password. I can guess at the name but am not sure. I think I used an underline. Is there anyway of finding the database name?

There were three lines on the phpMyAdmin that said I needed to add a password which I did.

No I cannot get into phpMyAdmin. I have uninstalled and reinstalled multiple time to no avail. I get

Welcome to phpMyAdmin

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.

I have looked at correction action on the web, and tried it, rebooted, etc, all resulting in same error.

How do I either unset root passwords or move forward?

I read it was not a good idea to put passwords in .ini files so I don't know what to.

I have an IT background but haven't done development for quite some time, so this is new to me.

Thanks

Read »

Created by Dplanet 2 years 13 weeks ago
Category: Installation Tags:

Login to post comments

phpMyAdmin Error #1045 17 weeks 13 hours ago

I was developing a new drupal 7 site on a local WAMP server.
Using phpMyAdmin, I tried to remove privileges to the site from an existing user and I guess succeeded in removing privileges from the 'root' user.
Now I can't get into phpMyAdmin anymore instead I get this:
"Error: #1045 - Access denied for user 'root'@'localhost' (using password:" YES)"

#1045 error message 2 years 44 weeks ago

I have just put Drupal on a second PC to help me learn how to use it. I Installed WAMP and copied default.settings.php and changed it settings.php. I created the first database "drupal" and added a password. Then when I went to http://localhost/phpMyAdmin.php I get the message below. How and where do I change the settings that allow me in?

ERROR

My SQL Said

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

phpMyAdmin Errors 2 years 38 weeks ago

Hello.

I'm in the process of trying to install Drupal (from http://drupal.org/node/307956) on my computer and am at the point where I need to modify phpMyAdmin (step 3 of "Download and Install Drupal"). I'm receiving the following errors:

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

Connection for controluser as defined in your configuration failed.

error cannot conect invalid settings 2 years 34 weeks ago

Hi I tried to access the database on drupal acquia stack 2.2.15
Mysql database server 5.4.18

I got an error access denied

MySQL said: Documentation
Cannot connect: invalid settings.
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.
Open new phpMyAdmin window

My Drupal site disappeared when I reset the root password of MySQL! 3 years 46 weeks ago

I am new to drupal. I intended to instal a drupal main site and multiple test sites in my uniserver installed on my PC. Following the installation instruction regarding multiple sites. I installed a drupal 6.12 main site following the instruction to configure it with a no password access to mySQL.

I succeeded in successfully installing and saving this without further action on the main site. In trying to install the test sites I tried to access the test sites databases via phpmyadmin only to discover that I can no longer access mysql because of Error #1045 Access denial.

Site having Error: PDOException: SQLSTATE[28000] [1045] Access denied 1 year 28 weeks ago

Hi
I am new to Drupal. I had downloaded and installed drupal 7.7 along with WAMP2
(following these instructions)
I was able to access the site yesterday. Now when I try to open my site in localhost I get the following error:
PDOException: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) in lock_may_be_available() (line 164 of C:\wamp\www\site1\drupal-7.7\includes\lock.inc).

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 1 year 37 weeks ago

I can't get mySQL to run even though I have the correct password.

I had drupal6 running on a website and foolishly tried to upgrade from 6.16 to 6.22 by uninstalling 6.16 and then installing 6.22. I was having simple directing problems and I tried fixing things in myphpadmin. I deleted my root directory and then things took a turn for the bad. mySQL could no longer run and I have no idea how to fix it.

I've tried reinstalling phpmyadmin and everything related to mySQL and still do not have any luck getting it to run. I know mySQL is running because when I type in:

Problems in copying site from a public server to a development environment on local machine 2 years 26 weeks ago

I have read the handbook and several other articles and have been unsuccessfully working on this all week and now I might have ruined it totally.
My local environment is Windows 7, XAMPP 1.7.3, phpMyAdmin 3.2.4, Apache 2.2.14, MySql 5.1.41 and PHP 5.3.1 and the server is phpMyAdmin 3.2.4, Apache 2.2.16, MySql 5.0.91 and PHP 5.2.14.
Recently I uploaded another site from my local machine to the server and that went ok.
However I have not been unable to reverse the situation from another site.

Drupal Database Problem 1 year 44 weeks ago

root@debian:/home/venu# mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
root@debian:/home/venu# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 47
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license