By Dogger on

I am getting this error

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

* Are you sure you have the correct username and password? (yes i deleted the db and readded it to make sure and i know its right)
* Are you sure that you have typed the correct database hostname? (yup possitive)
* Are you sure that the database server is running? (yes its running)

Ideas?

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

are you sure the DB is located at localhost ?

Dogger’s picture

Dogger commented

Its actually on the web server... Not sure what to set it do

i chanced it to the web address and i get this now
Failure to connect to your MySQL database server. MySQL reports the following message: Unknown MySQL server host 'http' (1).

kscheirer’s picture

kscheirer
Primary language English
Location Vallejo
commented

sounds like your syntax is just a little off. you don't need the "http://" at the beginning of your web server's address.
--
AchieveInternet
http://www.achieveinternet.com

vm’s picture

vm commented

The db server won't be your domain name. If the Database is located on the same server as your account you use localhost. If the Database is located on a seperate server you have to use the DB address which won't be localhost.

logging into phpmyadmin and looking at the top of the page sometimes helps, otherwise you may have to ask your host, or check your hosts documentation for your DB location.

Dogger’s picture

Dogger commented

yea it is localhost

Server: localhost - Database: ouellett_sellsaz

vm’s picture

vm commented

double check that your host doesn't use a automatically add a prefix in your DB name and your username.

zeta ζ’s picture

zeta ζ commented

Is the user deansel the username you granted permissions to, on the database? (not the one that logs into MySQL)
___________________
It’s in the detaιls…
demonstration portfolio

Dogger’s picture

Dogger commented

yes it is the database user name

kscheirer’s picture

kscheirer
Primary language English
Location Vallejo
commented

well if the error is still "Access denied for user 'deansel'@'localhost'" then its most likely a problem with your password. Are you sure its correct, and that the user 'deansel' has access to the database you're trying to use?

--
AchieveInternet
http://www.achieveinternet.com

prezaeis’s picture

prezaeis commented

the problem is one of these 3:

wrong username
wrong password or
wrong database name

or a combination of the 3

styro’s picture

styro commented

deansel@localhost and deansel@my.db.hostname are two different accounts to MySQL. You'll need to make sure the MySQL user account you created is deansel@localhost and not deansel@something.else.altogether

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal