5.8 connect to db problem
Dogger - July 21, 2008 - 22:35
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?
=-=
are you sure the DB is located at localhost ?
Its actually on the web
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).
sounds like your syntax is
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
=-=
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.
yea it is localhost Server:
yea it is localhost
Server: localhost - Database: ouellett_sellsaz
=-=
double check that your host doesn't use a automatically add a prefix in your DB name and your username.
Users
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
yes it is the database user
yes it is the database user name
well if the error is still
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
the problem is one of these
the problem is one of these 3:
wrong username
wrong password or
wrong database name
or a combination of the 3
Also keep in mind that
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