Unable to change db sqllite to mysql

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

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

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to change db sqllite to mysql

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

On Fri, 12 Jul 2019, 1:45 am john samuel, <[hidden email]> 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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to change db sqllite to mysql

john samuel
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 <[hidden email]> 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, <[hidden email]> 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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to change db sqllite to mysql

Jorge Gimeno

On Thu, Jul 11, 2019 at 6:55 PM john samuel <[hidden email]> wrote:
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 <[hidden email]> 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, <[hidden email]> 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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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

Are you using VS Code by chance?

-Jorge
 

--
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 [hidden email].
To post to this group, send email to [hidden email].
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/CANfN%3DK-7%2BKSs16F5xitLd-qe5KLRZ2_RL6QeYvMFp4H0RgMQPw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to change db sqllite to mysql

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

Regards,
Amitesh Sahay


On Friday, 12 July, 2019, 07:56:33 am IST, Jorge Gimeno <[hidden email]> wrote:



On Thu, Jul 11, 2019 at 6:55 PM john samuel <[hidden email]> wrote:
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 <[hidden email]> 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, <[hidden email]> 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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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

Are you using VS Code by chance?

-Jorge
 

--
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 [hidden email].
To post to this group, send email to [hidden email].
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/CANfN%3DK-7%2BKSs16F5xitLd-qe5KLRZ2_RL6QeYvMFp4H0RgMQPw%40mail.gmail.com.
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 [hidden email].
To post to this group, send email to [hidden email].
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/2036646095.341506.1562925353823%40mail.yahoo.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Unable to change db sqllite to mysql

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

On Fri, 12 Jul 2019, 15:26 'Amitesh Sahay' via Django users, <[hidden email]> wrote:
Try to use 'UTF-8' instead of 'utf8mb4' and see if that works.

Regards,
Amitesh Sahay


On Friday, 12 July, 2019, 07:56:33 am IST, Jorge Gimeno <[hidden email]> wrote:



On Thu, Jul 11, 2019 at 6:55 PM john samuel <[hidden email]> wrote:
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 <[hidden email]> 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, <[hidden email]> 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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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.

--
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 [hidden email].
To post to this group, send email to [hidden email].
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

Are you using VS Code by chance?

-Jorge
 

--
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 [hidden email].
To post to this group, send email to [hidden email].
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/CANfN%3DK-7%2BKSs16F5xitLd-qe5KLRZ2_RL6QeYvMFp4H0RgMQPw%40mail.gmail.com.
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 [hidden email].
To post to this group, send email to [hidden email].
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/2036646095.341506.1562925353823%40mail.yahoo.com.
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 [hidden email].
To post to this group, send email to [hidden email].
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/CAE45hvNnTH3Pt8WnOBDh4NPGN%3D94cs%3DV9gxxCbYpSqYmbDbHfg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.