operational error in django database connection

Question

I have setup the MySQL database in django. but I am getting the operational error such as unknown database.

DATABASES = {
'default': {
    'ENGINE': 'django.db.backends.mysql',
    #'ENGINE': 'mysql.connector.django',
    'NAME': os.path.join(BASE_DIR, 'dbname'),
    'USER':'root',
    'PASSWORD':'********',
    'HOST':'localhost',
    'PORT':'3306',
}

}

But it throws following error:

django.db.utils.OperationalError: (1049, "Unknown database 'c:\users\brahmareddy\desktop\djangotable\checkingapp\djangodb'")

the 'ENGINE' is 'django.db.backends.mysql' but you want to connect to 'c:\users\brahmareddy\desktop\djangotable\checkingapp\dbname' -- I think it is sqlite. — Yang HG
– Yang HG, Commented Apr 2, 2019 at 7:40

Anurag · Accepted Answer · 2019-04-02 07:42:10Z

1

your setting for mysql database should look like this

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql', 
        'NAME': 'DB_NAME',
        'USER': 'DB_USER',
        'PASSWORD': 'DB_PASSWORD',
        'HOST': 'localhost',   # Or an IP Address that your DB is hosted on
        'PORT': '3306',
    }
}

Name should not contain path, it is just the name of already running MySQL instance

Host is the IP Address of the MySQL server

answered Apr 2, 2019 at 7:42

Anurag

3,12422 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Brahma Reddy Over a year ago

i used this these parameters. but again its throws the same error.

Anurag Over a year ago

can you paste the error here? also do have MSSql instance running somewhere with whom you want to connect to?

我要改名叫嘟嘟 · Accepted Answer · 2022-04-08 03:20:30Z

0

If you use docker, maybe you should check the docker volume.

docker volume --help
docker volume ls
docker volume  rm xx yy

Remove cache, restart.

answered Apr 8, 2022 at 3:20

我要改名叫嘟嘟

1698 bronze badges

Collectives™ on Stack Overflow

operational error in django database connection

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related