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',
}}
On Fri, 12 Jul 2019, 1:45 am john samuel, <johnsamuel....@gmail.com> wrote:
> Hi Guys,
> I've done everything from installing sql,setting up of root and password
> till xampp server installation and setting the port number correctly with
> right installation of sqlclient and editing Database in setting as
>
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.mysql',
> 'NAME': 'Listo',
> 'USER':'root',
> 'PASSWORD':'',
> 'HOST':'localhost',
> 'PORT':'3307',
> 'OPTIONS':{
> 'init_command':"SET sql_mode='STRICT_TRANS_TABLES'",
> 'charset':'utf8mb4',
> },
> 'TEST': {
> 'CHARSET':'utf8mb4',
> 'COLLATION':'utf8mb4_unicode_ci',
> }
> }
> }
>
>
> But i am still getting an error...kindly help me...
> Traceback (most recent call last):
> File "manage.py", line 21, in <module>
> main()
> File "manage.py", line 17, in main
> execute_from_command_line(sys.argv)
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py",
> line 381, in execute_from_command_line
> utility.execute()
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\management\__init__.py",
> line 357, in execute
> django.setup()
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\__init__.py",
> line 16, in setup
> from django.urls import set_script_prefix
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\urls\__init__.py",
> line 1, in <module>
> from .base import (
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\urls\base.py",
> line 8, in <module>
> from .exceptions import NoReverseMatch, Resolver404
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\urls\exceptions.py",
> line 1, in <module>
> from django.http import Http404
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\http\__init__.py",
> line 5, in <module>
> from django.http.response import (
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\http\response.py",
> line 15, in <module>
> from django.core.serializers.json import DjangoJSONEncoder
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\serializers\__init__.py",
> line 23, in <module>
> from django.core.serializers.base import SerializerDoesNotExist
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\serializers\base.py",
> line 7, in <module>
> from django.db import models
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\__init__.py",
> line 3, in <module>
> from django.db.models.aggregates import * # NOQA
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\aggregates.py",
> line 5, in <module>
> from django.db.models.expressions import Case, Func, Star, When
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\expressions.py",
> line 8, in <module>
> from django.db.models import fields
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\__init__.py",
> line 11, in <module>
> from django import forms
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\__init__.py",
> line 6, in <module>
> from django.forms.boundfield import * # NOQA
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\boundfield.py",
> line 3, in <module>
> from django.forms.utils import flatatt, pretty_name
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\forms\utils.py",
> line 6, in <module>
> from django.utils import timezone
> File
> "C:\Users\Admin\AppData\Local\Programs\Python\Python37\lib\site-packages\django\utils\timezone.py",
> line 11, in <module>
> import pytz
> ValueError: source code string cannot contain null bytes
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To post to this group, send email to django-users@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/68059107-83c1-4dc8-accd-68ff69145312%40googlegroups.com
> <https://groups.google.com/d/msgid/django-users/68059107-83c1-4dc8-accd-68ff69145312%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAP-kQennpm5m_Yq2ChVNvps7tY1eF5_9bpi3gwLk5bV4k1QHJg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
