comiventor comiventor - 1 year ago 89
MySQL Question

Unable to connect mysql via django

I know this is an old question on lots of forums with answers suggesting to do flush privileges and reset passwords but in my case no answer has worked.

Here's the scenario:

I am able to connect to mysql via following command

mysql -u root -p -hlocalhost

I am also able to connect via python using following script

import MySQLdb
Con = MySQLdb.Connect(host="", port=3306, user="root", passwd="mypass", db="mydb")
Cursor = Con.cursor()
sql = "SELECT * FROM test"
Cursor.execute(sql) #### gives 1L

But I am unable to connect via Django. Django contains

'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'mydb',
'USER': 'root',
'PASSWD': 'mypass',
'HOST': 'localhost',
'PORT': '3306',

Following is the main error

django.db.utils.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")

Please suggest.

Answer Source

The key for the password value in the db settings should be "PASSWORD", not "PASSWD".

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download