By Zkeeler on

Howdy,
For those with little patience with newbies; PLEASE DO NOT READ FURTHER
Im very new to this and a bit overwhelmed by the steep learning curve.

here is what i did:
installed Xampp in the root af a separate harddisk
started apache and mysql with xampp_start.exe
moved phpMyAdmin to the htdocs directory
created a database
copied dropal 6.0 files into th htdocs directory
opened firefox=>http://localhost/
so far so good
dropalscreen (i'm happy)

install drupal in english

database type: mysql
database name: testsite
database name: Mike

following error
Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'mike'@'localhost' (using password: NO).

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?

a little bit of help would be very much appreciated

/Mike

⋅ Categories: Drupal 6.x

Comments

jscoble’s picture

jscoble commented

Congratulations on getting that far.

The error message provides you with both the problem the trouble shooting steps you need to go through.

Access denied means exactly that, you do not have access to the database you attempted to access. The most common reasons are:

*the user you are using to access the database does not have the necessary privileges to do so.
-did you GRANT the user 'mike'@'localhost' privileges to the database testsite? If not, you need to do so.

*incorrect username/password combination. If you did grant the user 'mike'@'localhost' privileges on the database testsite, make sure you are using the exact username/password combination that you used in your GRANT statement. Remember username/password is case sensitive.

*The database you are trying to connect to is not the one you granted privileges to, testsite. This will sometimes result in a different error.

*The database is on a different host than the one you specified. Since this is a XAMPP install, most unlikely.

*The database server is not running. The XAMPP control panel can show you the status of your MySQL server.

The GRANT statement, replace only the emphasized text with your values:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost'
IDENTIFIED BY 'password';

It also helps to get a minimal understanding of the basics of the components you are using and do searches on the errors that you receive. I'm sure this has been asked/answered many times before on Drupal's forums, MySQL's and XAMPPs.

Zkeeler’s picture

Zkeeler commented

OK thanks.

I will try to work this out.

The last part of my post (which i deleted before sending) was this:

Since you're here , maybe one more question
I am not a computer expert (as you must have noticed by now) but I'm willing to learn. since I have to learn a lot of different things at the same time xampp/pphpmyadmin/MySQL/drupal it is a bit difficult to understand what i am doing and why.
Most tutorials are written for a specific program and assume you understand the other programs. Since I don't i do not know whee to start so i thought:"just dive in the deep end" can you recommend a site or book in order to get a better understanding of this stuff?

thanks
/Mike

jscoble’s picture

jscoble commented

I was just pointing out that searches on the error would have provided you with the answer too. One reason why some people react negatively to n00b questions is because of the appearance of ask first instead of searching for the answer first, especially for questions that have been answered many times before.

It's understandable that getting a grip on everything involved in Drupal, or any other software that interacts with many other pieces of software, can be overwhelming and I am not suggesting that learning everything there is to know is what should be done first. Even experienced people come across problems/situations that they haven't encountered before.

However, when one encounters an error or a problem, searching on that error and reading the documentation of the software component(s), as it relates to that error, is a good place to start. In the case of your query, it would have been MySQL and database access since that was the software involved and the type of error involved. The best place would have been MySQL's website.

You will often find that people recommend you go to the website of the software you are having problems with for a resolution. While the Drupal community does its best to help those in need, it is volunteer and the community cannot provide answers for every possible software and environment combination that Drupal may interact with. Just as MySQL's forums probably wouldn't be the best place to get answers to Drupal questions.

Good luck.

BTW, did you get your access issue resolved?

Zkeeler’s picture

Zkeeler commented

patience, time and a lot of reading...

I didn't work on solving the issue anymore, I was tired and well over my coffee limit...maybe later today.

well it its later today and it works...thanks

danschaller’s picture

danschaller commented

Just out of curiosity (and for the edification of others who read this string later) what did you find as the ultimate problem and solution?
I've found that it's usually user permissions, but sometimes it's more esoteric. Thanks.

==========================
SERRV International
a 501(c)3 Fair Trade organization for more than 50 years.

ltownsend’s picture

ltownsend commented

I am trying to install Drupal on my local server. I'm running MAMP on a Mac OS X.4.11 Intel 1.83 dual core IMac 1G RAM

In order to simplify things (and after trying numerous passwords/user Ids/database names checking & rechecking spelling) etc...

Database: drupal
User: drupal
password: drupal

however when I try to install Drupal I get:

Failed to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'drupal'@'localhost' (using password: YES).

* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct database hostname?
* Are you sure that the database server is running?

For more help, see the Installation and upgrading handbook. If you are unsure what these terms mean you should probably contact your hosting provider.

Now, I have set up Drupal perfectly at work working under a very similar computer system. OS X.5 Intel 1.83 dual core IMac (newer) 2G RAM

I suspect that this might be where the error is coming from -- about 2 years ago I installed php and mysql (without MAMP) in order to design a blog. And while I have turned off the old MySQL in the preferences, my suspicion is that the older php installation is mixing badly with my new installation/MAMP, but I haven't got a clue where to uninstall it.

I've cleared caches, give my user all accesses, did a bunch of google searches on my error message, increased php.ini memory to 32M etc... but still nothing.

Any help would be appreciated.

melwyn.s’s picture

melwyn.s commented

I had the same issue ..finally got the hint to my error from the second guy who replied ..

I use phpmyadmin for managing the database...logged in ...clicked on the new database i created ( multisite).. clicked on privileges at the top ..checked what was the username ...which was root by default for mysql (while i was using the drupal username like a noob, which i am during the drupal install).. And voila it worked :) This one error made me waste probably more than an hour fiddling with different setting files wondering where i have gone wrong.. so thanks to the guy with the simple answer :D

If that dosent help you check if the database name you created and the database is the same ..and still dosent work then all the best..

Also there are so many documentations for multi site which tell you to do things diffirently ...finally got the answer from someone saying that older documentations were for older versions ..so it kinda makes life more difficult for the noobs ..

forumId’s picture

forumId commented

I ran into this today and it was carelessness on my part - I had renamed default.settings.php when the instructions clearly said COPY! So, that is another reason you can get this error

flameijpzmt’s picture

flameijpzmt commented

I've found that it's usually user permissions, but sometimes it's more esoteric.

mschore’s picture

mschore commented

I am not a newbie to web development or administering Windows servers, however, I am new to Drupal. I am very frustrated with the fact that the configuration of the database hangs with NO ERROR MESSAGES! At least you were getting an error message to work with. I am only getting a return to the database information form. This is nuts.

mschore’s picture

mschore commented

To follow up to my previous comment, I have since installed the Acquia-Drupal install at php.iis.net without a problem. Why is this when the drupal.org fails without error messages? I don't mind getting error messages--at least I have something to work with.

simonium’s picture

simonium commented

I have exactly the same probem, I'm installing Drupal 6.14 on WAMP 2.0 (php 5.3.0) on Vista (unfortunately) - The Database Configuration screen just hangs with no error messages.

I set up my database and user in phpMyAdmin - they are set up correctly, I am entering the right info on the database config screem, the file permissions are ok. If I purposely enter the wrong information then I get an error message, but if I enter the correct information, the the screen page just refreshes.

anyone else ever have this problem?

tvik’s picture

tvik commented

This helped me:
http://www.alwaysgetbetter.com/blog/2008/11/24/drupal-stuck-at-database-...

einsteinsboi’s picture

einsteinsboi commented

You can go back to the wampserver website and download the 5.2.11 version of PHP (http://www.wampserver.com/en/addons_php.php) and install it, and then when you click the Wampserver icon, go to PHP, then version, you can choose to work with version 5.2.11 instead of 3.0.

As for getting stuck with the database config page, make sure that in sites/default, you have two files: default.settings.php and settings.php. Don't just rename default.settings.php, you have to copy it and then rename the copy.

Hope this helps.