login community faq

I'm getting the following error message when trying to 'syncdb' for the first time. I upgraded my project from django 1.3 to the format or django 1.4.x on my development machine where it works. On the webfactional server I get this error. I believe I have all the settings in settings.py correct but I must be missing something.

1
2
3
   File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 187, in __init__
      super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'mysite'@'localhost' (using password: YES)")

I have created a db called mysite_db. Here are my db settings (settings.py):

DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'mysite_db', 'USER': 'myusername', 'PASSWORD': '****', 'HOST': '', 'PORT': '', } }

Any ideas as to what would cause this?

asked Oct 20 '12 at 10:48

Roland's gravatar image

Roland
32

edited Oct 20 '12 at 10:52

If your username and database name are set to the same in your settings.py then maybe try connecting with phpmyadmin to make sure you can connect with the username and password you are using. If you still have trouble, maybe open a support ticket for us to take a closer look for you.

(Oct 20 '12 at 11:19) bmeyer71 ♦♦ bmeyer71's gravatar image

Sorry to mislead. My database name is my username but ending with _db, which is legal according to the docs.

username: myusername database: myusername_db

I have opened a ticket because it appears that there is also a server error when I try to view my site with a browser.

(Oct 20 '12 at 11:28) Roland Roland's gravatar image
Be the first one to answer this question!
If you have an answer to the above question, then use the form below. Otherwise, use the appropriate 'add new comment' button above to post your feedback.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×17

Asked: Oct 20 '12 at 10:48

Seen: 455 times

Last updated: Oct 20 '12 at 11:28

Plans & prices    Sign up    Why WebFaction?    Contact us    Affiliate program    Support    Legal    Jobs    Blog    Control panel login
Powered by OSQA
© Copyright 2003-2012 Swarma Limited - WebFaction is a service of Swarma Limited