By patgreen on

I installed web-developer suite 1.9.5 and Drupal 5.2. After I filled in all the info on the database configuration page, it kept giving me this error message "Failure to connect to your MySQL database server. "MySQL reports the following message: Access denied for user 'XXXX'@'localhost' (using password: YES)."

I tried to use the command line as described in the install.mysql file, I got the same message. It seems like something is fundamentally run with my MySQL installation. CAn anybody help? Thanks!

⋅ Categories: Drupal 5.x

Comments

mikeschinkel’s picture

mikeschinkel commented

Stupid questions, yes, but:

  1. Did you create a database first?
  2. Did you create a user for that datbase?
  3. Did you give that user rights to the database?

If yes to the above, what tool did you use to create the database?

Also, can you post the entire error message page?

-Mike

patgreen’s picture

patgreen commented

I first installed Net Developer Suite 1.9.5. Then I unizipped the Drupal 5.2 and copy all files to the \webroot folder. I noticed when I install the Net Developer Suit it did not ask me to fill out anything, no password and anything for MySQL.

I tried to setup a database following the instruction in the Install.Mysql.txt file provided by Drupal. I typed in all the commands using Command Prompt. Both mysqladmin and mysql resulted in the same response "Access denied to the user...".

And this is the error message when I click "save configuration" on the database configuration page:

Failure to connect to your MySQL database server. MySQL reports the following message: Access denied for user 'patgreen'@'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.

I looks like I did not set the database right. Could you tell me how using Net Developer Suite? Thanks

aaryn015’s picture

aaryn015 commented

Do you mean Microsoft .Net Developer Suite? Does that even include PHP and Mysql? Pretty much everyone here on Windows will use WAMP. http://www.wampserver.com/en/

This isn't a Drupal issue, and I've never used this server app before so I won't waste anymore of our time, but you're probably better off either installing WAMP or checking out a forum on Net Developer Suite, or the documentation. You are looking for details on how to change/add MySQL users to the database.

Once you have done that part, you just need to match the username and password in the Drupal setup.

aaryn015’s picture

aaryn015 commented

If you are referring to the program here: http://www.devside.net/ then it seems that it automatically creates databases and users for various popular CMS systems including Drupal.

A quick search on their forum (http://forums.devside.net/index.php) reveals the default usernames and passwords for MySQL:

User: "root"
Pass: "rootwdp"

The rest can be found here: http://www.devside.net/download/wd-guide/security.html

Note that if you use the "drupal_user" user account, you will also need to use the "drupal" database that is pre-installed with the server software, as this is the only database that account has permissions for. (e.g. don't create your own database).

ehodul’s picture

ehodul commented

Hi patgreen, I installed Web.Developer Suite 1.9.5 and I can not acces mysql - the user/password root/rootwdp does not work for me. I tried to access it through mysqladmin and also http://localhost/phpmyadmin/ - the same problem. Please advice. Thanks!

aaryn015’s picture

aaryn015 commented

Your mysql username or password is incorrect. Make sure you have this set correctly in your settings.php file.

It needs to match what you have setup on the MySQL server. For Wamp, the default is 'root', password is '' (blank).

A quick fix is to go to phpMyAdmin->Privledges and follow the form for adding a new user.

aaryn015’s picture

aaryn015 commented

Sorry, I mentioned settings.php, does'nt apply if you havn't installed. The username and password are entered incorrectly on the installation form.

rhalio’s picture

rhalio commented

this is the way to solve the problem. as said above:
database name:(as you gave when creating a database on wampserver>phpmyadmin)
database username:root
password:(blank)
worked for me:)

devside_net’s picture

devside_net commented

The Web.Developer Server Suite comes with Drupal pre-configured for our particular configuration/setup and the MySQL database already contains the Drupal user/permissions/database setup.

The installation procedure is to hit http://localhost/drupal/install.php . Nothing needs to be created, edited, or input. You should see the 'create 1st user page' right after this.

Web.Developer Server Suite v2.00 is now integrated with Drupal v5.3 and you can see the latest Community edition Documentation here...
http://www.devside.net/download/suite-guide/index.html

armyofda12mnkeys’s picture

armyofda12mnkeys commented

also wanted to mention i had this problem in drupal 6.4 and 6.5 in IIS/windows where dont really need to set permissions on default install (just in case gave access to IUSR_machinename).
what worked was manually putting in the database connection string in drupal's settings.php file