Unable to change db sqllite to mysql

[john samuel]

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

[SHREERAM KULKARNI]

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',
    }
}

--
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...@googlegroups.com.
To post to this group, send email to django...@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.
For more options, visit https://groups.google.com/d/optout.

[john samuel]

Hi shreeram,

But the fact is that i  have changed the port number in xampp server for mySQL as 3307.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAP-kQennpm5m_Yq2ChVNvps7tY1eF5_9bpi3gwLk5bV4k1QHJg%40mail.gmail.com.

[Jorge Gimeno]

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. 

Are you using VS Code by chance?

-Jorge

 

[Amitesh Sahay]

Try to use 'UTF-8' instead of 'utf8mb4' and see if that works.

Regards,

Amitesh Sahay

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CANfN%3DK-7%2BKSs16F5xitLd-qe5KLRZ2_RL6QeYvMFp4H0RgMQPw%40mail.gmail.com.

[john samuel]

Ok bro...I'll try and let you know...

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2036646095.341506.1562925353823%40mail.yahoo.com.