Why am I getting django.db.utils.InternalError: (1049, "Unknown database 'db'")?

Question

Django

I have this:

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

then I run python manage.py migrate and get this:

django.db.utils.InternalError: (1049, "Unknown database 'mydb'") ?

If you create a database via mysql in the console, then it works, but the database is created in /var/lib/mysql
How can I make the database be created at the root of the project?

Answer 1

You are confusing mysql and sqllite databases.

Answer 2

In "NAME" you write the name of the database that you created in the MySQL server.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mydb',
        'USER': 'root',
        'PASSWORD': 'password',
    }
}

When connecting to a local database, there is no need to specify the host and port.