Hi shreeram, But the fact is that i have changed the port number in xampp server for mySQL as 3307.
On Thu, Jul 11, 2019 at 9:19 PM SHREERAM KULKARNI < [email protected]> wrote: > 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, <[email protected]> > 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 [email protected]. >> To post to this group, send email to [email protected]. >> 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 [email protected]. > To post to this group, send email to [email protected]. > 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 > <https://groups.google.com/d/msgid/django-users/CAP-kQennpm5m_Yq2ChVNvps7tY1eF5_9bpi3gwLk5bV4k1QHJg%40mail.gmail.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 [email protected]. To post to this group, send email to [email protected]. 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/CAE45hvOwwXt2YDb652kn4aeNcBa4yG-0Om9tGfb-6N%3DT9Ru3cg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
