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="127.0.0.1", 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

DATABASES = {
    '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.

Subscribe
Share

alter ‘PASSWD’: ‘mypass’ to ‘PASSWORD’: ‘mypass’,


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Check your database for permissions, log into MySQL and run

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

FLUSH PRIVILEGES;