Unable to connect mysql via django

August 30, 2015 1.1k views
Django MySQL

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 settings.py 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.

1 comment
1 Answer

Check your database for permissions, log into MySQL and run

GRANT ALL ON *.* TO 'root'@'localhost';

Have another answer? Share your knowledge.