Access denied for user 'my_username'@'localhost' (using password: YES)")

Question

I do this:

python manage.py syncdb --settings=settings_real

But I get this:

_mysql_exceptions.OperationalError:
  (1045, "Access denied for user 'my_username'@'localhost' (using password: YES)")

I have tried changing the password and made sure that the password is correct.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'my_database',
        'USER': 'my_username',
        'PASSWORD': 'my_password',
        'HOST': '',
        'PORT': '',
    }
}

I get the same problem when I try to connect to the database using the CLI application.

Any ideas?

UPDATE: For what it's worth, I just created a new database and connected with the generated password. Seems to work fine. I'd still like to know what's wrong with the old setup.

Accepted Answer

0

Your database user name is not the same as your account user name. Your database user name is the same as the name of your database. So, if your db name is "my_database", then you should use that as your database user name.

Hope that helps!

permanent link

answered 01 Nov '10, 15:06

seanf ♦♦
9.3k●1●9●28
accept rate: 38%

Access denied for user 'my_username'@'localhost' (using password: YES)")

Follow this question

Got questions? We have answers!

Related questions